How to init an object type
I have the following code : CREATE OR REPLACE TYPE ObjB IS OBJECT (
CREATE OR REPLACE TYPE ObjC IS OBJECT (
CREATE OR REPLACE TYPE ObjCArr IS VARRAY(100) OF ObjC; CREATE OR REPLACE TYPE ObjA IS OBJECT (
a ObjA; I've tried to initialize a, but each time I have an ORA-06530 error. Any idea how to initialize it using Oracle 8.1.7 ? Nusa If you want to initialize, use: DECLARE a ObjA := ObjA(NULL,NULL,ObjB(NULL,NULL),ObjCArr()); Note: Since element a.Ac is a VARRAY of objects ObjC, you would have to use a.Ac.EXTEND;
to add elements to VARRAY. You can not add it using: a.Ac.EXTEND;
You can use already existing a.Ac(1).C1 or a.Ac(1).C2 for existing elements only. Solomon Yakobson
Have a Oracle Question
Oracle Books
Oracle Application
Oracle Home
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|