Being the paranoid SOB I clear the table in both places. It is an in memory
table and as part of the package it is per session and not shared among
sessions. I just initialize the table, I found it in the docs and at
asktom. I am at home and don't remember the syntax.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Marcelo Vinagreiro" <mlv_2001_at_terra.com.br> wrote in message
news:2cc92fd4.0304300523.5ba7b7ce_at_posting.google.com...
> 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 - 09:20:09 CDT
