Re: How to set trigger status "valid" on Oracle 9i

"Show Errors" wont usually work for a trigger. Try "Select * from user_errors;".

Niall Litchfield wrote:

> 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.
>>>
>>