Re: Obtaining Rowid after insert into ... values ...

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1996/11/08
Message-ID: <55vpma$g70_at_shadow.CSUFresno.EDU>#1/1


Using the DBMS_SQL package from SQL*Plus and the LAST_ROW_ID function will do the trick.

Steve Cosner

In article <3281F86D.B6E_at_deakin.edu.au>, Neville Grills <nevilleg_at_deakin.edu.au> wrote:
>Is there a way of getting the rowid of the row inserted into
>a non-keyed table immediately after an insert into ... values (...)
>in PL/SQL or SQL*Plus. Forms must be able to do it as it can update the
>inserted record, and it appears to be available to the OCI via the Comms
>area, but I can't find any documentation on finding it in Oracle
>manuals.
>
>Help would be appreciated.
>
>Neville ( replies by e-mail would be appreciated :)
  Received on Fri Nov 08 1996 - 00:00:00 CET

Original text of this message