Skip to main content
Question

Trace procedure calls with parameters

  • Jul 9, 2020 9:54 AM UTC
  • 3 replies
  • 154 views

Forum|alt.badge.img+1
  • Do Gooder (Customer)

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)
  • Aug 19, 2020 4:28 AM UTC

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)
  • Aug 19, 2020 6:21 AM UTC

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)
  • Aug 19, 2020 6:23 AM UTC

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.