CREATE OR REPLACE
TYPE test_obj3 AS object
(t1 NUMBER(5), t2 VARCHAR2(30),t3 VARCHAR2(3000));
/
CREATE OR REPLACE
TYPE test_type_3 AS varray(10)
OF test_obj3;
/
CREATE OR REPLACE PROCEDURE obj_typ (p_obj_array IN test_type_3,
result_cursor OUT types.ref_cursor
)
AS
TYPE table_type2 IS VARRAY (3) OF test_type_3;
r_tab table_type2 := table_type2 ();
BEGIN
FOR i IN 1 .. p_obj_array.COUNT
LOOP
DBMS_OUTPUT.put_line (p_obj_array (i).t1 || p_obj_array (i).t2 || p_obj_array (i).t3);
r_tab.EXTEND ();
r_tab (i):= p_obj_array(i).c1;
END LOOP;
OPEN result_cursor FOR
SELECT r_tab (1), r_tab (2)
FROM DUAL;
END;
/
i am getting error
12/7 PL/SQL: Statement ignored
12/34 PLS-00382: expression is of wrong type
can any one please let us know where we are going wrong and suggest