Re: Here is a good one ;-)

FWIW, I don't understand the stuff Sybrand is talking about - I haven't come across it yet (or had to).

What I would do at this point is break out the manuals (hey!) and check the syntax on the INSERT statement as there is apparently a RETURNING clause that looks interesting. Plus, I'd search the docs/google for packaged global variables.

HTH Andrew

"Jeff Boyer" <jdboyer@(remove)icomproductions.ca> wrote in message news:9ii1ta$toa$1_at_news3.cadvision.com...
> Sorry, I am somewhat new to these things........ yes, I am using Oracle
 8i
> but I am not familure with either things you mentioned. Can you give an
> example of one?
>
> Thanks again,
> Jeff

 <snip>
> > If you are on 8i you could easily use the returning clause of the insert
> > statement.
> > Also you could assign the sequence value to a packaged global variable,
 and
> > you could retrieve it's currval to further process it, provided you do
 that
> > right after the insert.
> > *NO* Need at all to put in yet another temporary table.
> >
> > Regards,
> >
> > Sybrand Bakker, Senior Oracle DBA
Received on Sat Jul 21 2001 - 16:32:42 CDT