Home » Developer & Programmer » JDeveloper, Java & XML » How to send structure datas with a CallableStatement
How to send structure datas with a CallableStatement [message #91404] Wed, 14 August 2002 09:14 Go to next message
Ultimalutin
Messages: 1
Registered: August 2002
Junior Member
Hi

I would like to know how to send datas to a stored procedure called by a Callable statement...
I saw that we can make it with a array type variable (OracleTypes.ARRAY) but it's a bit complicated.

Do you know if we can send a parameter mapped as a OracleTypes.CURSOR or other structures...

Thanks.
Ultimalutin
Re: How to send structure datas with a CallableStatement [message #91532 is a reply to message #91404] Thu, 24 October 2002 04:59 Go to previous message
Manoj
Messages: 101
Registered: August 2000
Senior Member
Try using this code
CallableStatement cstmt1 = null ;

cstmt1 = con.prepareCall("{call procedure_name(?)}") ;
cstmt1.setObject(1, paramtype, targetSqlType);
cstmt1.execute();

try using setObject on CallableStatement
hope it works out

Manoj
Previous Topic: Re: sample test questions for OCP exams IZO-501/502/504/505
Next Topic: JSP Problem
Goto Forum:
  


Current Time: Mon Jul 26 10:58:32 CDT 2021