Re: How to get compilation error when creating database trigger in SQLPLUS

Try:

SQL>show errors trigger trigger_name

Aarre Heikkilä
aarre_at_dlc.fi

On Thu, 17 Sep 1998 14:33:13 +0800, XXX <bei_at_umac.mo> wrote:

>When I attempt to create a database trigger (with some errors) in
>sqlplus 3.3.2, I will get the flolwing message
>'Warning: Trigger created with compilation errors.'.
>If I try to use 'show errors' just like creating procedure in sqlplus,
>there will be
>no errors.
>
>How can I know the errors when I attempt to create database trigger in
>sqlplus.
>
>Thanks in advance.
>
Received on Thu Sep 17 1998 - 13:11:00 CDT