Re: Rowid after an insert???

Steve Cosner wrote:
>
> I need to know the rowid of a single row that I have just inserted. I
> have searched through all the Oracle documentation that I have, and
> can't find anything even close.
>
> In Forms 4.5, after committing new rows, the newly inserted rows
> contain the new rowid's, so Forms is doing something special to get
> the value back from the server.

At the OCI level, the ROWID is returned in the Cursor Data Area after a single row insert (or delete or update or select for update). This is doubtless where Forms gets it from.

There doesn't seem to be anything at the PL/SQL level to enable you to get at this field. Logically it ought to be SQL%ROWID, but it isn't. Received on Tue Sep 10 1996 - 00:00:00 CEST