Re: fetch : looking for equivalence between Informix and Oracle

Well, another good place to look (in addition to the Oracle docs) is :   http://osi.oracle.com/~tkyte/ResultSets/index.html.

Tom does a fabulous job of explaining things.

hth,
cindy

"Daniel A. Morgan" wrote:

> mpcazalet wrote:
>
> > Hi,
> > I'm new in using oracle database.
> > I'm looking for the command with oracle to return a data set in a stored
> > procedure .
> > With Informix I used to write the following command :
> >
> > Create Procedure (...) RETURNING a, b, c ;
> >
> > For each cursor For select ....
> >
> > Return a1,b1,c1 With Resume;
> >
> > End Foreach;
>
> What you are asking for does not translate into Oracle.
>
> Look at returning a REF CURSOR but the implementation is different.
>
> You will need to open an Oracle book to learn how to use it to accomplish
> your goal.
>
> Daniel A. Morgan
Received on Sun May 20 2001 - 16:46:29 CDT