Oracle-L: Re: PL/SQL and Forms 4.5

From: Subramaniam, Sridhar <SSubrama_at_NIBUCORP.CCDN.OTC.COM.AU>
Date: Wed, 10 Jan 1996 02:06:37 -0500
Message-Id: <9601100715.AA04066@alice.jcc.com>

You can't do this. FORMS 4.x supports 1.1v of PL/SQL. Since record/table types are PL/SQL v2 specific, you cannot pass record/table type constructs thro' procedural objects to FORMS 4.x. The version of PL/SQL bundled with FORMS 5.0 ( Dev 2.0 ) will be at sync with the database version. May be then you could do this.

Regarding the cursor spec in the package, it didn't work when i tried on 7.0.16 and 4.0.x. I couldn't access constants/exceptions declared in packages thro' FORMS. Haven't tried this in 4.5.x. I believe it will not work owing to the disparity in the PL/SQL versions.

Let me know, if ever, you succeed

Sridhar Subramaniam
Telstra Corporation
Email : ssubrama_at_nibucorp.ccdn.otc.com.au

avion_at_ozemail.com.au

From: owner-oracle-l
To: Multiple recipients of list ORACLE-L Subject: PL/SQL and Forms 4.5
Date: Tuesday, 9 January 1996 9/59AM

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 Wed Jan 10 1996 - 02:15:29 CST