Re: Debugging PL/SQL

Zhao wrote:

>Is there a simple tool comes with Oracle package (or out there) which show
>at least where is compiling error (which line and what was wrong)?
>
>Thanks
>
>

Yeah. It's called SQL*Plus. After you see a message indicating a error in compilation you type:

SQL> SHO ERR You might also find:

SQL> desc user_errors

of interest.

Why buy a tool when what you want is free?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)