trace PL/SQL stored procedure
680810Jan 20 2009 — edited Jan 20 2009Hi,
I'm working with Oracle since only few weeks. I worked on Informix before.
On informix we had the possibilty to put a stored procedure in trace with following line in the stored procedure :
if gv_f_trace is not null then
set debug file to gv_f_trace with append;
trace on;
end if;
So it was very easy on site or in integration system to put stored procedure traces in a file in order to analyse errors.
Is there the same "tool" with oracle PL/SQL? if not how can i do to analyse a stored procedure?
thanks,
Olivier