RE: passing several columns into single array using RETURNING clause in java

From: Anthony Molinaro <amolinaro_at_wgen.net>
Date: Tue, 3 Aug 2004 11:26:28 -0400
Message-ID: <D17DB304A9F42B4787B68861F9DAE61C033F9C@wgdc02.wgenhq.net>

Tanel,
  I only put sql in directly in jdbc if it is extremely simple, = otherwise I'm using plsql in jdbc.
  I'm not sure how to make a prepared statement accept an OUT parameter = ( I believe the values in a RETURNING clause=20   must be treated like OUTs in jdbc ).
  I was under the impression you could only do it with a callable = statement.
  But, I'm no java pro, so I could be wrong. Maybe metalink?   Is the requirement to do this in JDBC, because this would be a breeze = in pro*c.

-----Original Message-----
From: Tanel P=F5der [mailto:tanel.poder.003_at_mail.ee]=20 Sent: Tuesday, August 03, 2004 10:30 AM
To: oracle-l_at_freelists.org
Subject: Re: passing several columns into single array using RETURNING = clause in java=20

Thanks Anthony!

Is there a way to do this with a single update called from JDBC, without = PL/SQL as well? I know it's possible with OCI, but I'm not that familiar = with Java, so maybe anyone of you can give me some pointers...

Thanks,
Tanel.

Original Message -----=20 From: "Anthony Molinaro" <amolinaro_at_wgen.net> To: <oracle-l_at_freelists.org> Sent: Tuesday, August 03, 2004 5:04 PM Subject: RE: passing several columns into single array using RETURNING = clause in java

> Tanel,
>
> I'd use a callable statement. Also, I'm assuming later on in the=20
> code =3D you may want to treat the=3D20
> array like a table, ie, select * from table( :array );, so use an =
=3D=20
> array of objects instead
> of a composite associative array.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put = 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Aug 03 2004 - 10:22:15 CDT