retrieving multiple rows from stored procedures in forms 4.0

I'm trying to figure out how I can call a stored procedure from Forms 4.0 and have it bring back multiple rows.

I know you can bring back multiple rows in stored procedures with the TABLE datatype, but I read somewhere that forms 4.0 still uses version 1.0 of PL/SQL, and so you can't declare a TABLE datatype in forms itself. Also, I don't believe there is a 'declare, procedure,execute,fetch' with stored procedures like there is in Powerbuilder.

If you have any ideas, please let me know. Thanks Received on Sun Apr 16 1995 - 00:00:00 CEST