Re: 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 don't think you can

/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

True. Forms 4.0 and 4.5 (Developer/2000) still use PL/SQL V1

/itself. Also, I don't believe there is a 'declare,
/procedure,execute,fetch' with stored procedures like there is in
/Powerbuilder.

The TABLE type is one column and an index. You can't return a whole row.

/If you have any ideas, please let me know. Thanks

You can declare a public cursor in a package. Repeated calls to a procedure in the package could use the cursor to get rows.

I have heard rumors that Oracle 7.2 will allow passing of a cursor as a parameter.
Can anyone confirm?

David Roth

CMC Systems                                       All opinions expressed
UNIX Client/Server System Integrators      are my own.