Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: JDBC and RefCursor

Re: JDBC and RefCursor

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Wed, 6 Feb 2002 17:13:17 +0400
Message-ID: <a3ra7d$8tq1@news-dxb.emirates.net.ae>


If i have understood u right ... U need to Get a Ref Cursor as a Output Parameter from a Stored proc... Then see Below...

You can use the Types.Cursor to pass and retrive the RefCursor.

U need to use callable Statement to call the Proc and register the Out Parameter as a Types.Cursor Value.

HTH

--
[Additions and Corrections Welcome.]
Regards,
Ganesh R
"Oliver Huppert" <Oliver.Huppert_at_pikon.com> wrote in message
news:a3r65t$5ce$07$1_at_news.t-online.com...

> Hi all,
>
> someone knows how to pass a ref cursor to a stored procedure in oracle?
>
> Perhaps an example?
>
> Thanks
> Olli
>
>
Received on Wed Feb 06 2002 - 07:13:17 CST

Original text of this message

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