Procedure or function to create insert scripts on table

3574779

Hi,

I have a requirment to monitor dml statements on few tables  and gather the scripts.we have dba audit table but we are not getting required data some times

Can we write a procedure to genrate insert script on tables passed as parameter.

Later can we use that procedure in dml trigger to generate the script values and store in a table as clob value.please give ur suggestions

John Thorton

3574779 wrote:Hi,I have a requirment to monitor dml statements on few tables and gather the scripts.we have dba audit table but we are not getting required data some times

What required data is  missing?

Can we write a procedure to genrate insert script on tables passed as parameter.

I give up.

Can you?

Later can we use that procedure in dml trigger to generate the script values and store in a table as clob value.please give ur suggestions

Your specific requirements are unclear

Please read the content of URL below & respond accordingly.

How do I ask a question on the forums?

Why are NONE of your threads marked as ANSWERED?

3574779