Re: Compile errors in stored procedures
From: Diana Tracy <bs794_at_cleveland.Freenet.Edu>
Date: 29 Jan 1994 04:04:37 GMT
Message-ID: <2icn8l$3b_at_usenet.INS.CWRU.Edu>
Date: 29 Jan 1994 04:04:37 GMT
Message-ID: <2icn8l$3b_at_usenet.INS.CWRU.Edu>
In a previous article, MDOWNING_at_ESTEC.BITNET (Michael Downing) says:
>Use
>
>Select * from user_errors;
>
>It will display the current errors, this view is cleared down when you attempt
>another recompilation of the same package.
>
I didn't see the original query, so this may be a supid answer, but if the
question is: How can I see the compile errors for stored procedures? the
easiest answer is
SQL> show err
-- Diana Tracy, System Designer -- Excitement, Adventure bs794_at_cleveland.Freenet.Edu -- and Really Wild ThingsReceived on Sat Jan 29 1994 - 05:04:37 CET