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

Home -> Community -> Usenet -> c.d.o.misc -> Returning a value in a Java Insert

Returning a value in a Java Insert

From: Robert Boyle <rboyle_at_cyantel.com>
Date: 1 Jul 2002 01:29:02 -0700
Message-ID: <8729a6fe.0207010029.42f698f0@posting.google.com>


Hi there

We are running 8.1.7 and I am wondering if we can return a value via an SQLJ insert.

In plsql this would be

INSERT INTO table (col1) values (value1) RETURNING col1 INTO var1;

I think we should be able to do this in an anonymous plsql block executed from Java but have had no luck in doing so.

Cheers
R. Received on Mon Jul 01 2002 - 03:29:02 CDT

Original text of this message

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