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

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 3 Aug 2004 17:29:58 +0300
Message-ID: <01fb01c47966$5ad0e080$9c969fd9@porgand>

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 ----- 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 code =
> you may want to treat the=20
> array like a table, ie, select * from table( :array );, so use an =
> 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
-----------------------------------------------------------------

Received on Tue Aug 03 2004 - 09:25:52 CDT