Create a class with wrapper methods for DBMS_APPLICATION_INFO

This is a discussion on Create a class with wrapper methods for DBMS_APPLICATION_INFO within the Oracle Database forums, part of the Database category; and call the appropriate class.method before executing the SQL you want to trace. -- and remember to clear DBMS_APPLICATION_INFO after ...

		Exforsys > Database > Oracle Database
Create a class with wrapper methods for DBMS_APPLICATION_INFO

LinkBack

Thread Tools

#1 (permalink)

01-25-2006, 12:33 PM

JazzHarmonicat JazzHarmonicat is offline

Junior Member

Join Date: Jan 2006

Posts: 1

JazzHarmonicat is on a distinguished road

Create a class with wrapper methods for DBMS_APPLICATION_INFO

and call the appropriate class.method before executing the SQL you want to trace. -- and remember to clear DBMS_APPLICATION_INFO after running the SQL you want to trace.

You could also create methods to turn on and off SQL tracing.

For those of you wondering what DBMS_APPLICATION_INFO is, check Tom Kyte's "Ask Tom" section on Oracle's website. There's also something in his book.

« - | ORA-00923: FROM keyword not found where expected »

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new questions You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT -4. The time now is 12:06 AM.