Re: Mutating Triggers in Oracle

Thanks, Jim!

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:<%uIra.675949$F1.89490_at_sccrnsc04>...
> I did it thusly.
> Created a type that is the record I want.
> Created a table of that type. (in a package)
> Procedures in the package
> Clear table
> Add a record to the table (this table is in memory)
> Write the in memory table to where ever I wanted it.
>
> In the before statement trigger on table A I clear and initialize the table
> of the type.

But, how could I clear the table? I don't know the oracle syntax for this.

Could I clear the pl/sql table at the end of the statement trigger (3)? Or is necessary to create a before statement trigger?

Finally, are there any problem if we clear the plsql table?

Best regards!

Marcelo

> In the after row trigger I fill up the table of type with records.
> In the after statement trigger I write the information from the table of
> type records to wherever I wanted.
>
> Jim
>
Received on Wed Apr 30 2003 - 08:23:53 CDT