-
create or replace TYPE assay_attribute_struct AS object(
ASSAY_ID NUMBER(10),
attribute_no NUMBER(3),
Attribute_id NUMBER(10),
parent_attribute_no NUMBER(3),
Attribute_type VARCHAR2(20),
DISPLAY_UNIT VARCHAR2(20),
display_order NUMBER(3),
Update_values_from_index NUMBER(1),
Creation_date DATE,
parent_display_order NUMBER(3));
TYPE vAryAssay_attribute IS VARRAY(500) OF assay_attribute_struct;
I have defined vAryAssay_attribute like this in sqlplus.
declare
name aimads_pack.vAryAssay_attribute := aimads_pack.vAryAssay_attribute(assay_attribute_struct(NULL,NULL,41,NULL,'Defining-Fixed',NULL,NULL,1,NULL,NULL),assay_attribute_struct(NULL,NULL,41,NULL,'Defining-Fixed',NULL,NULL,1,NULL,NULL));
is this correct?
ThanX
Raj
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|