Re: simple trigger question

In article <32F3859C.2FA0_at_qrcsun.qrc.org>, wslun_at_qrcsun.qrc.org says...
>
>John Holland wrote:
>>
>> I'm trying to create a simple trigger. I get a warning: trigger created
>> with compilation errors message. When I say show errors it says NO ERRORS.
>><Code Deleted>

I had (still have) this problem. All I do is select * from user_errors for any triggers that I am in the processes of checking out syntax errors.

Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 SEQUENCE                        NOT NULL NUMBER
 LINE                            NOT NULL NUMBER
 POSITION                        NOT NULL NUMBER
 TEXT                            NOT NULL VARCHAR2(2000)

This will tell you what is wrong. Good luck.

Later..........dy Received on Sun Feb 02 1997 - 00:00:00 CST