-----Original Message----- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: 06 October 2005 11:30 To: List - DBI users Subject: Oracle and dbh -> last_insert_id
Hi Folks I can't get last_insert_id() to work with Oracle. OS: GNU/Linux DBI: V 1.48 Oracle: 9.2.0 Demo (to save you typing): http://savage.net.au/last.pl I've tried various values for catalog and schema, including the schema for the (test) table. Any idea? -- Cheers Ron Savage, [EMAIL PROTECTED] on 6/10/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company I would doubt that dbd Oracle supports this. I would recommend using the insert...returning clause, INSERT INTO emp (empno, ename) VALUES (seq_emp.NEXTVAL, 'Morgan') RETURNING empno INTO x; Ken.