RE: Does Oracle Allow Retrieval of Parsed Insert Statement??

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C08BCE.80414650
Content-Type: text/plain;

        charset="iso-8859-1"

You do not need OCI to do it. Returning supported everywhere one can use SQL.   Alex Hillman

-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com] Sent: Wednesday, January 31, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: Does Oracle Allow Retrieval of Parsed Insert Statement??

> -----Original Message-----
> From: Sam Bootsma [ mailto:SamB_at_cpas.com <mailto:SamB_at_cpas.com> ]
> Sent: mercredi, 31. janvier 2001 10:31
> To: Multiple recipients of list ORACLE-L
> Subject: Does Oracle Allow Retrieval of Parsed Insert Statement??
>
>
> We have a situation where we insert rows into a table, without having
> knowledge of the primary key. One of our developers needs to
> determine the
> rowid of such a row (primary key unknown) immediately after the row is
> inserted into the table.
>
> Does anybody know if the rowid can be retrieved (or somehow returned)
> immediately after the row is inserted (without requerying the table)?
Received on Wed Jan 31 2001 - 15:40:59 CST