Obtaining Rowid after insert into ... values ...

From: Neville Grills <nevilleg_at_deakin.edu.au>
Date: 1996/11/08
Message-ID: <3281F86D.B6E_at_deakin.edu.au>#1/1

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

This message: [ Message body ]
Next message: Steve Cosner: "Re: Obtaining Rowid after insert into ... values ..."
Previous message: Steve Cosner: "Re: Forms 4.5 Display Problems"
Next in thread: Steve Cosner: "Re: Obtaining Rowid after insert into ... values ..."
Reply: Steve Cosner: "Re: Obtaining Rowid after insert into ... values ..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message