Thanks for taking care of my question.
Yes, I'm on 8i. Sorry for that;
There problem to get the returning clause of the insert statement :
the insert statement is done in a Oracle program that I don't have the
source.
The After Insert trigger that I'm thinking to install is just to correct an
error in this process.
A TAR has been entered since now 2 months ago, Oracle patches after patches
have been installed but are not helping a lot.
So, my CURRVAL is not the correct answer to this, following you ?
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:vkhme76hfvf962_at_corp.supernews.com...
>
> "Guy Van Rinsveld" <guyvanrinsveld_at_hotmail.com> wrote in message
> news:3f48ce81$0$26208$ba620e4c_at_reader1.news.skynet.be...
> > How to know the key which has been inserted in the After-Insert trigger
?
> > Some update are to be done on this new record.
> > I remember the CURRVAL.
> > But will it be always the corresponding generated key given by this way?
> >
> >
>
> Assuming you are on 8i or higher -which you don't mention, but always
> should- use the returning clause of the insert statement
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
Received on Sun Aug 24 2003 - 11:18:02 CDT
