Re: Stored procedure that acts like a cursor?

Yes it is. You can use referenced cursors and pass these in and out of procedures.

You could also do the same with PL/SQL tables. Check Oracle Doc for more info.

Pro

Albert Ratzlaff wrote in message <3614D1BD.FB51E18B_at_infonet.com.py>...
>Hi all!
>Is it posible to write a stored procedure that acts like a cursor. For
>example, I have a procedure that generates a lot of lines of text.
>Normally I would write the lines to an operating system (Unix, in this
>case) file. For diverse reasons, the procedure runs on the server.
>The question is, can I do "something" within Forms (4.5) to activate
>(equivalent to "open cursor") the stored procedure and then "fetch" a
>line at a time?
>
>Thanks in advance for any suggestions!
>
>Regards
>Albert Ratzlaff
>
Received on Sat Oct 03 1998 - 19:43:57 CEST