--- In firebird-support@yahoogroups.com, 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.