Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle/ODBC/Procedure/Cursor -- how ?
Hi,
In article <6fb7ja$ld0$1_at_nnrp2.dejanews.com>, "ShivKumar"<vihs_at_rocketmail.com>
wrote:
>
> I want to execute a stored procedure in Oracle7.
[snip]
> How do I execute this procedure using ODBC/JDBC ??
[snip]
> • But how do I get the value from this record ?
> • What type of variable should I bind for parameter#2 in MYPROCEDURE ?
[a REF CURSOR]
You probably need to use the REFCURSOR as a Java ResultSet, at least that's what I gather from the info at http://www.oracle.com/st/products/jdbc/. But I fail to see why you want to use a stored procedure at all here. Why don't you simply put the select in your JDBC code?
Cheers,
Karel Sprenger <ks_at_ic.uva.nl> | phone: +31-20-525 2302 Informatiseringscentrum | +31-20-525 2741 Universiteit van Amsterdam | fax : +31-20-525 2084 Turfdraagsterpad 9, NL-1012 XT AMSTERDAM | home : +31-20-670 0942 *** PGP Public Key available on servers *** | email: <cjas_at_xs4all.nl>Received on Fri Mar 27 1998 - 00:00:00 CST