Oracle Stored Procs and JDBC
Date: 1997/12/18
Message-ID: <3499A5B1.274A6134_at_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 CET