Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trace PL/SQL stored procedure

680810Jan 20 2009 — edited Jan 20 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2009
Added on Jan 20 2009
3 comments
396 views