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: Oliver Huppert <Oliver.Huppert_at_pikon.com>
Date: Wed, 6 Feb 2002 14:44:45 +0100
Message-ID: <a3rbt1$2ej$00$1@news.t-online.com>


No the other way. The procedure has an ref cursor as IN-Parameter.

"Ganesh Raja" <ganesh_at_gtfs-gulf.com> schrieb im Newsbeitrag news:a3ra7d$8tq1_at_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:44:45 CST

Original text of this message

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