Re: Adding stored procedures with SQL*Plus

From: <rsthomas_666_at_my-dejanews.com>
Date: Thu, 18 Mar 1999 02:00:37 GMT
Message-ID: <7cpmo1$iek$1@nnrp1.dejanews.com>

In article <7cotfp$sij$1_at_nnrp1.dejanews.com>, tiger_woods_at_my-dejanews.com wrote:
> I have a file with a stored procedure listing in it. When I import it, using
> SQL*Plus using @filename.sql, it spits out
>
> Warning: Procedure created with compilation errors.
>
> How do I find out what the compilation error is?
>
> Thanks,
> David
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

AT THE SQL PROMPT TYPE
SQL> show errors

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 20:00:37 CST