Re: How to reference object types within Forms 6.0

I am having a similar problem. I've created objects, but can't use them in my form. Every time I compile a procedure it gives me a message saying the object type is invalid. This does not happen if I compile it in the PL/SQL editor.

I found this possibly important statement in the help files:

"This release of Oracle Developer uses PL/SQL 8 on the client and the server. Client-side program units currently cannot support Oracle8 object-related functionality. However, stored program units can use all the new PL/SQL 8 features. Appendix A in the PL/SQL User's Guide and Reference manual describes the new PL/SQL 8 features."

If you have made any progress in solving your problem I would like to hear about it. Good luck.

In article <0263a43d.990587b0_at_usw-ex0106-047.remarq.com>,   Troy Tuttle <troytNOtrSPAM_at_vii.com.invalid> wrote:
> 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!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 14 2000 - 00:00:00 CEST