Tell me more ×
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.
up vote 0 down vote favorite
1

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 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 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 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 at 17:27

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.