Nested table as a out parameter in procedure [message #644356] |
Tue, 03 November 2015 12:19 |
|
aspire
Messages: 18 Registered: September 2015 Location: TVN
|
Junior Member |
|
|
i am trying to use a nested table as a out parameter in procedure. It is throwing error when i execute.
---pkg spec
CREATE OR REPLACE PACKAGE PKG_BBM IS
TYPE REC IS RECORD(EMPNO NUMBER, ENAME VARCHAR2(90));
TYPE TAB IS TABLE OF REC;
PROCEDURE PRC1(LV_TAB OUT TAB);
END PKG_BBM;
/
----pkg body
CREATE OR REPLACE PACKAGE BODY PKG_BBM IS
PROCEDURE PRC1(LV_TAB OUT TAB) IS
BEGIN
FOR I IN (SELECT EMPNO,ENAME FROM EMP) LOOP
LV_TAB.EXTEND;
LV_TAB(LV_TAB.LAST).EMPNO := I.EMPNO;
LV_TAB(LV_TAB.LAST).ENAME := I.ENAME;
END LOOP;
END PRC1;
END PKG_BBM;
/
-----------execution part
DECLARE
TA PKG_BBM.TAB ;
BEGIN
PKG_BBM.PRC1(TA);
END;
ORA-06531 --reference to uninitialized collections
thanks in advance
|
|
|
|
|
|