Re: Trigger

From: Andrew Allen <andrew.allen-contr_at_trw.com>
Date: Fri, 06 Jan 2006 19:37:08 GMT
Message-ID: <EFzvf.1874$fb4.465@newssvr14.news.prodigy.com>

Zephyr wrote:
> Hi,
>
> I'am using ORACLE Server + Client 9.2.0.4.0.
>
> While creating triggers within SQLPlus* I get the message:
>
> Warning: Trigger was created with compilation errors
>
> If I executer 'show errors' I get : No errors.
>
> Is there a parameter that can be switched to show the errors?
> Any hints?
>
> Thanks
> Patrick
>

Try SHOW ERRORS TRIGGER (or other object type) <schema>.<object name> should list the errors.

Andrew Received on Fri Jan 06 2006 - 13:37:08 CST