Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> INSERT RETURNING INTO Clause

INSERT RETURNING INTO Clause

From: Bill Mann <bill.mann_at_worldtalk.com>
Date: Mon, 21 Jun 1999 00:19:44 -0700
Message-ID: <376DE790.62B6A21B@worldtalk.com>


It's appears that DBI and DBD:ORacle does not support returning values from a SQL INSERT.

Can anyone confirm this please.

Thanks,
Here is the SQL
"INSERT INTO %s VALUES (
  ids.nextval, '%s', %s, '%s',
  %s, %s, fs.currval||'%s', %s, NULL, NULL)   RETURNING imkey INTO ?",

Here is the error from Oracle:

DBD::Oracle::st execute failed: ORA-03108: oranet: ORACLE does not support this interface version (DBD: oexec error) at vfsora.pl line 454, <STDIN> chunk 2. Received on Mon Jun 21 1999 - 02:19:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US