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)?

The rowid can also be determined by parsing the insert statement, retrieving the primary key, then querying the table for the rowid of the row. Does anybody know if Oracle has an OCI call that returns components of a parsed SQL INSERT statement. Or does anybody have a script or procedure that parses a SQL INSERT statement?

Thanks for any help. Received on Wed Jan 31 2001 - 12:32:54 CST