Retrieving the key of a newly inserted record

From: Claus Scherschel <claus_scherschel_at_operamail.com>
Date: 20 Dec 2002 19:38:57 GMT
Message-ID: <Xns92EAD1FBA8FC9clausscherschelarcor@130.133.1.4>

Hi everyone,

I'm using an after insert trigger/sequence combination to create an incremental number for the table's primary key.

I would like to write a stored procedure that executes an insert statement, writing the procedure's parameters into my table. That's not big deal. But I haven't a clue how to retrieve the primary key value of the new record. There's no other unique index which would help. Retrieving the row id would be sufficient, I think.

Database is Oracle 8.1.7.

Thanks in advance,

Claus. Received on Fri Dec 20 2002 - 13:38:57 CST