Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 :) –  tblPhil 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.