test trace does not show sql in called procedures

[billmil]

Hi,

This is a follow on from the post below.

is there a way w/ PLSQL developer "trace" facility to display a trace of statements executed by a called stored procedure?

i have a "test script" which declares and initializes some variables and calls a stored procedures. I'd like the trace output w/o having to run tkprof.

all I see currently are two entries:
"PL/SQL Virtual Machine started"

thanks,

bill milbratz

posted 2003-04-15 13:19
--------------------------------------------------------------------------------
After enabling SQL Trace and running a script in the test window, there is no output in the trace window. How can I get this output to show?
--------------------------------------------------------------------------------
Posts: 1 | From: San Antonio, TX, USA | Registered: Apr 2003 |

Marco Kalter

Administrator
Member # 2

posted 2003-04-16 13:09
--------------------------------------------------------------------------------
Unfortunately Oracle has 2 tuning features that have the word "Trace" in its name.
One is SQL Trace, which can be enabled in the Session menu. When enabled, all server processing caused by a SQL Window or Test Window will be logged in a trace file on the database server. One condition is that the timed statistics parameter of the database instance you are using must be set to true. You can view the information in the trace file by using Oracle's tkprof utility on the database server.

The other is the dbms_trace facility, which can be enabled in the Test Window by pressing the corresponding button on the Test Window toolbar. After execution of the Test Window you can switch to the Trace tab page to view the trace report.

I hope this helps.

------------------
Marco Kalter
Allround Automations

 

[Marco Kalter]

Could it be that you have disabled some or all trace events? If your program units are not compiled wit debug information, the trace events must be set to "All" instead of "Enabled" or "None":

You can configure which events you want to trace: Calls, Exceptions, SQL, or even every executed line of PL/SQL code. Press the Select Trace Levels button next to the Create Trace report button to bring up the configuration screen. You can control if you want to trace specific events in each program unit (All), only in those program units that are compiled with debug information (Enabled), or never (None).