Database Administration (MOSC)

MOSC Banner

MEMBER OF statement for nested table of records crashes with ORA-03113 on 11.2.0.4

edited Aug 25, 2016 5:01AM in Database Administration (MOSC) 2 commentsAnswered

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center