Re: Returning CURSORS from ORACLE STORED FUNCTIONS

Tech-Archive recommends: Fix windows errors by optimizing your registry

But the gist of this is = "Stored Functions are NOT supported via the
Microsoft .NET PRovider? Is that documented anywhere?

Thanks very much.

Cowboy (Gregory A. Beamer) - MVP wrote:
> You can wrap the function in a sproc and get it working. Not a
"great"
> option, but it works.
>
> To your question of compatibility: OracleClient is 8i compatible and
has
> some 9i functionality. Overall, I prefer ODP.NET (otn.oracle.com -
free
> download) to OracleClient for all but simple Oracle stuff.
>
>
> ---
>
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ***************************
> Think Outside the Box!
> ***************************
>
> "rpbinphilly" wrote:
>
> > Hi.
> > I have not been able to get a PLSQL stored FUNCTION to return a ref
> > cursor. (Stored Procedures work fine.)
> >
> > I get a ORA-06550 return codes, and other similar messages that
> > indicate that the C# OracleParameter should be of Direction type =
> > Output. Event though a call to .DeriveParameters returns a param of
> > type ReturnValue...
> >
> > It is a simple PLSQL function that returns a ref cursor and accepts
no
> > input parameters.
> >
> > I am using Oracle 10G and .NET Framework 1.1.
> >
> > Has anyone else experienced problems with this? Are there any known
> > limitations to the Microsoft .NET Oracle Provider? Any good sources
of
> > info?
> >
> > Any and all enlightenment gratefully received.
> >
> > Thanks in advance.
> >
> > rpb
> >
> >

.