Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Get rownum or rowid in insert URGENTT!!!!
> From David P, Glasgow, Scotland, UK
>
>
> Carlos - you probably wouldn'r be able to get the ROWID until you COMMIT
> 'ed.
>
HI David
Both Billy Verreynne above and you mentions that you cant get the rowid
before the insert is commited.
I think that with <insert into t values(...) returning rowid into my_var> I
can get the rowid fine.
What am I missing here?
Peter Laursen Received on Fri Nov 05 1999 - 02:57:36 CST