Re: Creating Audit Trail using triggers with 100 tables.

I don't appreciate your sarcasm. My trigger is more complex than this. I ask for this procedure to generate a script not an execute statement within the block. I want to be able to create a file so it can be modified if needed. Why don't you try reading the message in its entirety before responding. I realize I can generate it using nested loops and concatenations. I did not ask for anyone to do the work for me you idiot. I had generate a trigger script in the past but I had lost it.

P.S. I have figured it out without your aid. I just had the wrong settings.

"Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message news:3CB75DF9.155B560F_at_exesolutions.com...
> Don't have one handy but a a cursor against user_tables, a little
> concatenation, and one EXECUTE IMMEDIATE is all you need to do the job.
>
> I'm thinking oh 11 lines of code here.
>
> BEGIN
> OPEN cursor
> LOOP
> FETCH
> EXIT WHEN
>
> concatenate ...
> EXECUTE IMMEDIATE ...
> END LOOP;
> CLOSE cursor
> END;
>
> And I did it the long way. Do you really need someone to do it for you?
>
> If so, I question how carefully you've considered the implications.
>
> Daniel Morgan
>
>
>
> "Julian K. Black" wrote:
>
> > does anyone have a procedure that can generate a script to create an row
> > level trigger that will trigger on inserts, updates, and deletes.? My
> > schema is huge and I trying to avoid doing this manually.
>
Received on Sat Apr 13 2002 - 09:15:18 CDT