How to reference object types within Forms 6.0

From: Troy Tuttle <troytNOtrSPAM_at_vii.com.invalid>
Date: 2000/05/26
Message-ID: <0263a43d.990587b0_at_usw-ex0106-047.remarq.com>#1/1

Using PL/SQL release 8.1.5.1.0, I have created the following object types:

CREATE OR REPLACE TYPE cshbox_tender_rec AS OBJECT

	(	site_no			NUMBER(4) ,
		cshbox_no		NUMBER(6),
		name			VARCHAR2(12),
		report_name		VARCHAR2(12),
		expected_amt	        NUMBER(10,2),
		actual_amt		NUMBER(10,2)
	);

/

sho err;
CREATE OR REPLACE TYPE cshbox_tender_tab AS TABLE OF cshbox_tender_rec;
/

sho err;

I'm passing these object types as parameters in database package functions and procedures that are in-turn processed from Java Beans. I'd also like to use these same packages when I'm using Forms 6.0. However, when I when I make the following declaration in forms I get the error below:

	DECLARE
		cshbox_tender_tab_1	cshbox_tender_tab;
	BEGIN
                ....
	END;
		
	Forms Compiling error:
	   Error 960
	      "RPCs cannot use variables with schema level user-
               defined types in this release"

Any ideas on how to use these object types inside of forms?

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Fri May 26 2000 - 00:00:00 CEST