Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Stored Procedures and JDBC
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