Re: Oracle/ODBC/Procedure/Cursor -- how ?

From: Karel Sprenger <ks_at_ic.uva.nl>
Date: 1998/03/27
Message-ID: <6ffsr8$o8n$1_at_mail.ic.uva.nl>#1/1

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]

[Quoted] 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 [Quoted] fail to see why you want to use a stored procedure at all here. Why don't you [Quoted] 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 CET