Re: ref_cursor was (Sybase vs Oracle)?

First I called 5 experienced Oracle DBA's and only one had ever used Ref Cursors. She only described them to me as "not pretty".

Then I popped out the PL/ SQL book and tried my luck. After an hour I now understand why the other 4 DBAs have never utilized this feature.

joe

Thomas Kyte wrote:

> A copy of this was sent to Joe & Anne Buhl <jabuhl_at_worldnet.att.net>
> (if that email address didn't require changing)
> On 27 Nov 1998 04:48:47 GMT, you wrote:
>
> >
> >
> >
> >>
> >>
> >> >..... In Oracle all 'select' statements must put
> >> >their results *into* something within the stored proc, i.e., you can not
> >> >send the results of the 'select' directly back to the client ...
> >>
> >> False - use REF CURSORs for this excat reason. Available since 7.3.
> >
> >How exactly are the ref cursors implemented?
>
> as cursors, they are IN OUT parameters to procedures or return values from
> funtions.
>
> [snip]
>
> >
> >I have not seen any third party tools or even Oracle tools that take advantage
> >of ref_cursors. for instance in dbArtisan and Sybase you can excute a proc and
> >your results are there. You do that in Oracle from db artisan and ...........
> >
>
> Some Oracle tools:
>
> - sqlplus
> - svrmgrl
> - FORMS
>
> Some Non Oracle tools:
>
> - Crystal reports
> - netscapes web api stuff
> - powerbuilder
>
> and there are more in both catagories. Its a feature that has been part of
> Oracle since 7.2 -- sorry the exact tool you are using did not choose to support
> it. Its very each to use.
> >joe
> >
> >
>
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Herndon VA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> Anti-Anti Spam Msg: if you want an answer emailed to you,
> you have to make it easy to get email to you. Any bounced
> email will be treated the same way i treat SPAM-- I delete it.
Received on Wed Dec 02 1998 - 00:00:00 CST