|ORA-03001 while using bulk collect [message #224949]
||Fri, 16 March 2007 02:16
Registered: February 2007
i tried to create a procedure to learn the usage of bulk collect but i get the following error
oracle 9i version 184.108.40.206.0
SQL> create or replace procedure test_bulk_collect
5 v_var_execute varchar2(256);
6 v_value dbms_sql.varchar2_table;
8 v_var_execute:='select emp_no bulk collect into v_value from emps';
9 execute immediate v_var_execute;
10 for i in v_value.first..v_value.last loop
12 end loop;
14 end test_bulk_collect;
SQL> exec test_bulk_collect;
BEGIN test_bulk_collect; END;
ERROR at line 1:
ORA-03001: unimplemented feature
ORA-06512: at "APPS.TEST_BULK_COLLECT", line 9
ORA-06512: at line 1
and when i searched for the error message i got this
ORA-03001 unimplemented feature:
Cause: At attempt was made to use a feature that is not currently implemented.
Action: Do not attempt to use this feature at this time.
Check the compatible parameter and the optimizer_features_enabled parameter for your instance and make sure they are both up to the 9i version you are running.
if iam not wrong bulk collect is supported in oracle 9i.
please guide me..
[Updated on: Fri, 16 March 2007 02:22]
Report message to a moderator