Hi ..
I have created an Object type and nested table based on this object type and populating data to the nested table variable .
here getting the inconsistent data type error .
here is the code :
CREATE TYPE dept_obj AS OBJECT
(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13)
);
CREATE TYPE ty_dept_tbl IS TABLE OF dept_obj;
DECLARE
l_stmt VARCHAR2(1000);
cur_ref SYS_REFCURSOR ;
v_ty_tbl_dept ty_dept_tbl :=ty_dept_tbl();
v_int NUMBER :=0;
BEGIN
l_stmt := 'SELECT * FROM dept ';
OPEN cur_ref FOR l_stmt ;
FETCH cur_ref BULK COLLECT INTO v_ty_tbl_dept;
CLOSE cur_ref;
FOR v_cnt IN 1..v_ty_tbl_dept.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(v_ty_tbl_dept(v_cnt).deptno);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('The error is '||sqlerrm);
END ;
Getting this error The error is ORA-00932: inconsistent datatypes: expected - got -
Please suggest me how to fix this ..
The current version of Oracle is Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
I am sorry for being repeatative on this as I am practicing this for some project requirement .
Will really appreciate if any docs in regards to OORDBMS and Bulk collect be shared with me .
Thanks in advance
With immense gratitude .