Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a number of Oracle stored procedures whose activity I want to be able to audit, so I am having them INSERT some data into an auditing table. It would be swell if I could list the variables and their values as well.

Is it possible to get this list in an automated way? I am already using $$PLSQL_UNIT to get my procedure name.

share|improve this question
Yes. I don't have time to answer now. I'll give you a thorough answer on Sunday morning, but suspect somebody else will beat me to it :) – Phil Feb 23 '13 at 0:59
Thanks, @Phil - guess folks aren't very active here on the weekend. Looking forward to your input (as always)! – JHFB Feb 25 '13 at 13:50
Got it - all_arguments table and a cursor. I'll answer my own question once I have it all worked out. – JHFB Feb 25 '13 at 17:14
Nope, that won't get me the value... hmmm (I will remove these comments once I've found the solution) – JHFB Feb 25 '13 at 17:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.