PL/SQL and Forms 4.5

From: Alain Vullyamoz <vz_at_OFISA.CH>
Date: Tue, 9 Jan 1996 09:59:44 GMT
Message-Id: <9601090917.AA01462@alice.jcc.com>

Hi,

Does anyone know how to return a record variable (table_name%rowtype) from a stored package to Forms ?

What I'd like to do is the following :

in a Forms procedure, execute a stored procedure with a record's primary key as an IN parameter, and have the whole record as an OUT parameter, to be able to reference any column of the record from within my forms procedure.

Another solution might be having the cursor defined in the package specification and then acces it from within my forms procedure.

I tried both solutions, but without success

Can anybody help ?

TIA

Alain Vullyamoz                                 tel   : +41 21 341 81 11
Ofisa Informatique                              fax   : +41 21 341 84 57
Chemin des Charmettes 7                         e-mail: vz_at_ofisa.ch

CH 1003 Lausanne - Switzerland Received on Tue Jan 09 1996 - 04:18:02 CST