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 -> Re: Facing problem with CallableStatement

Re: Facing problem with CallableStatement

From: <raji_kb02_at_yahoo.co.in>
Date: 10 May 2006 02:35:39 -0700
Message-ID: <1147253739.903580.164930@i40g2000cwc.googlegroups.com>

First in Oracle you have to create SQL Type instead of PL/SQL type so that Java can see the datatype definition. Second in Java code you have to use ArrayDescriptor

Link below contains the sample code how to pass java array to oracle and get back the result

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:331217279811 Received on Wed May 10 2006 - 04:35:39 CDT

Original text of this message

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