-
CREATE OR REPLACE PACKAGE t_pack AS
TYPE vAryAssayId IS VARRAY(100) OF NUMBER(10);
TYPE AIMASSAY_cur IS REF CURSOR;
procedure ab;
END t_pack;
/
CREATE OR REPLACE PACKAGE BODY t_pack AS
procedure ab is
AssayIds vAryAssayId;
nvar_assayid number(10);
idx smallint;
asy_cur AIMASSAY_cur;
begin
OPEN ASY_cur FOR
SELECT DISTINCT ASSAY_ID
FROM ASSAY_ATTRIBUTE;
idx := 1;
LOOP
FETCH ASY_cur INTO nvar_assayid;
EXIT WHEN ASY_cur%NOTFOUND;
AssayIds(idx) := nvar_assayid;
idx := idx + 1;
END LOOP;
end ab;
END t_pack;
/
exec t_pack.ab;
is giving me error,
ERROR at line 1:
ORA-06531: Reference to uninitialized collection
ORA-06512: at "AMGENAIMDBO.T_PACK", line 16
ORA-06512: at line 1
Please help me,
ThanX in advance
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
|