always assuming that the trigger actually is valid. If it won't compile
issue show errors from sql*plus after trying to compile
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Syltrem" <syltrem_at_videotron.spammenot.ca> wrote in message
news:bhx88.4011$EI.21632_at_tor-nn1.netcom.ca...
> alter trigger xxx compile ?
>
> dunno about 9i. Works on 8i
>
> --
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
> To reply to myself directly, remove .spammenot from my address
>
> "odette" <odette.h_at_gmx.de> a écrit dans le message de news:
> 66e0618e.0202070737.5ecd557b_at_posting.google.com...
> > I've created an insert trigger on a database table, but the trigger
> > status is invalid! Who can tell me, how I can change the status to
> > valid? I just tried to alter the trigger via sql*plus worksheet, but
> > this had no effect.
>
>
Received on Thu Feb 07 2002 - 09:49:02 CST
