How to describe Neste Package OCI

[tamnguyen]

Hi everybody,

I can't describe the package that has content:

CREATE OR REPLACE PACKAGE TEST_NESTED_TYPES IS


TYPE EmpRecord1 IS Record (
LEVEL_NO NUMBER(1) default 1,
EMPNO NUMBER(4),
ENAME VARCHAR2(10),
HIREDATE DATE,
SAL NUMBER(7,2),
INSERT_FLAG boolean,
EmpRec2 EmpRecord2
);

TYPE EmpRecord IS Record (
EMPNO NUMBER(4),
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2),
INSERT_FLAG boolean,
EmpRec1 EmpRecord1
);


PROCEDURE add_employee_record(
empinfo in EmpRecord
);

END TEST_NESTED_TYPES;


I have use OCI function OCIDescribeAny(...) bug result is error.

Please tall me how to describe it.

Thanks,

Tam Nguyen.