Skip to main content
Question

Trace procedure calls with parameters

  • July 9, 2020
  • 3 replies
  • 136 views

Forum|alt.badge.img+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

  • Superhero (Employee)
  • 1495 replies
  • August 19, 2020

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.


Forum|alt.badge.img+4
  • Do Gooder (Employee)
  • 6 replies
  • August 19, 2020

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.


  • Superhero (Employee)
  • 1495 replies
  • August 19, 2020

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.