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

In SQL/PLUS,you'ld write a SQL command to get the compliation errors.

• Using the data dictionary 'USER_ERRORS' SELECT TO_CHAR(Line) || '/' || TO_CHAR(Position) Line_Pos, Text FROM USER_ERRORS WHERE NAME = '<your-trigger-name>';

XXX 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 - 04:35:52 CDT