Question

Trace procedure calls with parameters

  • 9 July 2020
  • 3 replies
  • 126 views

Badge +1
  • Do Gooder (Customer)
  • 2 replies

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:

 


3 replies

Userlevel 7

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.

Userlevel 2
Badge +4

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.

Userlevel 7

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