Trigger je neplatny :(

Jan Serak sherry na pikebo.cz
Pátek Září 1 10:47:50 CEST 2000


Milan Sorm wrote:
> Prvni napise Trigger zmenen, druhe Nebyly vybrany zadne radky. Show errors
> rekne "Bez chyb.". Presto update stale nefunguje s neplatnou hlaskou a
> validaci.

Tak jinak:

$ oerr ORA 4098
04098, 00000, "trigger '%s' is invalid and failed re-validation"
// *Cause: A trigger was attempted to be retrieved for execution and was
//         found to be invalid.  This also means that compilation/authorization
//         failed for the trigger.
// *Action: Options are to resolve the compilation/authorization errors,
//         disable the trigger, or drop the trigger.

Pokud tedy alter trigger ... compile; probehl dobre a bez chyb, je treba
proverit druhou moznou pricinu. Nemanipuluje trigger s necim, na co nema
pristupova prava (jine tabulky, sekvence,...)?

						Jan Serak


Další informace o konferenci Databases