Re: PLSQL debugging

Hi Sam,

forget about running scripts in sqlplus!

There are many good tools for PL/SQL developers:

1. T.O.A.D. is a very good tool that lets you run SQL statements, develop procedure, packages and triggers and many more... A freeware version is available at: http://www.toadsoft.com
2. For debugging PL/SQL procedures/packages try PL/SQL Developer: http://www.allroundautomations.nl/plsqldev.html

Hope this will help you,

Regards,

Sven Heins

Sam Jordan schrieb:
>
> Hi
>
> I'm experimenting with PLSQL and stored procedures. But whenever
> there is an error in my script with 'create procedure' and
> 'create package' statements, I only get the message
> 'Package/Procedure created with compilation errors' when running
> the script in sqlplus. This doesn't help much... I'd like to know
> where the error happens and I'd like to see a more detailed error
> message. Ideas?
>
> bye
> --
> Sam Jordan
Received on Tue Feb 16 1999 - 10:00:40 CST