Subject Re: Returning values from stored procedure
Author Alexander V.Nevsky
--- In, Mahesh Ishwar
<meghanshic@y...> wrote:
> Hi,
> I've a stored procedure in Oracle which takes in an integer as i/p
and returns back a cursor and 2 strings.
> I want to migrate the database to firebird, but I' m not getting how
can I return a cursor from stored procedure. Even if I use 'Suspend',
I would not be able to get the 2 string values along with that.
> My client applictaion is in .NET & I don't want to change it.
> Can anyone help me out in that.

Meghansh, I can say nothing about .NET but usage of Suspend in
procedure is common way in FB to get cursor from it by statement like
Select * From MySP. If you are trying to Execute MySP you'll get first
row only in output parameters. I do'nt know how force fetches in .NET
components/technology, but when you Select from SP it's ready to give
you all rows and waits to fetch commands.

Best regards, Alexander.