Skip to main content
Question

Trace procedure calls with parameters

  • 9 July 2020
  • 3 replies
  • 128 views

Is there possible to view the parameters values when a procedure call is done in background?

 

In debug window you can see the server trace, but theres no parameter values given, just the procedures names.
Example:

 

Is there possible to view the parameters values when a procedure call is done in background?

 

In debug window you can see the server trace, but theres no parameter values given, just the procedures names.
Example:

 

As far as I know the two options you have is either connect to the database through a tool like plsqldeveloper/Toad or you can look in Solution Manager\System Information and Utilities\Logical Units\PL/SQL Package Code.


Just use Copy option in the PL/SQL Details tab and copy it into a Pl/Sql developer

Then you can view parameters with values.


Just use Copy option in the PL/SQL Details tab and copy it into a Pl/Sql developer

Then you can view parameters with values.

Not for all the calls, which I assumed the question was about. 


Reply