Re: Stored procedure that acts like a cursor?

You can write a stored procedure that acts like a cursors with PL/SQL Release 2.2 and above (Oracle 7.2+).

However, you cannot access it from Forms 4.5. Forms 4.5 only supports PL/SQL Release 1.1

Forms 5.0 (Developer 2.0) supports PL/SQL 2.3.

'nuff reasearch from me for this thread... :-)

Albert Ratzlaff (albert_at_infonet.com.py) wrote:
: 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
:

-- 
(: Joe Brown :)				      joe_at_apache.dtcc.edu
I believe Wine is going to be great if it ever gets finished. . .
I believe Linux _is_ great even though it's not finished! ! !
I believe you have my address.  :-)