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