Re: PL/SQl: is there any debug tool?

From: Thomas Dunbar <tdunbar_at_gserver.grads.vt.edu>
Date: 1996/01/25
Message-ID: <310792F0.62FC_at_gserver.grads.vt.edu>#1/1


sl6gs_at_cc.usu.edu wrote:
> I compile the PL/Sql function with
> error, a error message" function created
> wiht compiling error ' , But it will never
> tell me which line is wrong , like in Cand Pascal,

end your pl/sql code with:

end;
/
show errors;

and it will give error msgs with line nrs (do a
  set serveroutput on
at the sqlplus prompt first, if that's not your default)

-- 
Thomas Dunbar    540 231-3938 (fax 3714)   http://gserver.grads.vt.edu/
Received on Thu Jan 25 1996 - 00:00:00 CET

Original text of this message