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 -> Oracle Stored Procedures and JDBC

Oracle Stored Procedures and JDBC

From: Billy Stevenson <bstevens_at_s10a5374.wcom.com>
Date: 1997/12/18
Message-ID: <3499A603.326B5049@s10a5374.wcom.com>#1/1

Does anyone out there know how to call an oracle stored procedure with oracle's JDBC
thin drivers? More specifically, the stored procedure has an in out parameter with a type
of ref cursor.
I am able to use regular data types to successfully pass parameters into

a stored proc.
I am also able to use the get a ref cursor back from an oracle function.

When I try to call the procedure, I always get the error of "wrong datatype or number of
parameters". I'm pretty sure it is because of the wrong datatype. The group that I am working with is using powerbuilder to call these procs and
they want me to use the same procs as them. Can anyone point me in a direction? I have looked at oracle and sun's site.
Thanks Received on Thu Dec 18 1997 - 00:00:00 CST

Original text of this message

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