MEMBER OF statement for nested table of records crashes with ORA-03113 on 11.2.0.4
Hello.
My current version of DBMS is 11.2.0.4.4 SE1.
The following code crashes with ORA-03113 on execution. It can also be compiled as a procedure with no compilation errors.
Does anyone have an idea how that can be fixed?
--create or replace procedure foo isDECLARE TYPE t_rec IS RECORD( func_id NUMBER ,func_brief VARCHAR2(100)); TYPE tt_rec_list IS TABLE OF t_rec; v_rec_list tt_rec_list := tt_rec_list(); v_rec t_rec;BEGIN FOR i IN 1 .. 9 LOOP v_rec_list.extend; v_rec_list(i).func_id := i; v_rec_list(i).func_brief := 'TEST' || i; END LOOP; v_rec.func_id := 1; v_rec.func_brief := 'asdfkjdsg'; -- false condition IF v_rec MEMBER OF(v_rec_list) THEN dbms_output.put_line('Member of collection'); ELSE dbms_output.put_line('Not member of collection'); END IF; v_rec.func_id := 1; v_rec.func_brief := 'TEST1'; -- true condition IF v_rec MEMBER OF(v_rec_list) THEN dbms_output.put_line('Member of collection'); ELSE dbms_output.put_line('Not member of collection'); END IF; --print all FOR i IN v_rec_list.first .. v_rec_list.last
0