Re: fetch : looking for equivalence between Informix and Oracle

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 20 May 2001 13:18:39 -0700
Message-ID: <3B08269F.456A569F@exesolutions.com>

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 - 15:18:39 CDT