Home » RDBMS Server » Performance Tuning » Bulk Collect in Oracle 8i
Bulk Collect in Oracle 8i [message #161286] Fri, 03 March 2006 01:19 Go to next message
mohit.arora79
Messages: 1
Registered: March 2006
Junior Member
Hi


I am trying to execute a function that works fine in Oracle 9i but it is throwing an error on compliling in Oracle 8i. Function text is as follows :-

create or replace procedure test_bulk_select is
TYPE t_row_array IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
v_row_id t_row_array;
v_table_name varchar2(30) := 'test_objects';
begin

EXECUTE IMMEDIATE 'SELECT rowid from ' || v_table_name BULK COLLECT INTO v_row_id;

dbms_output.put_line('done');
end;
/



Re: Bulk Collect in Oracle 8i [message #161336 is a reply to message #161286] Fri, 03 March 2006 05:47 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
BULK COLLECT INTO is not available in Oracle 8i. Open a cursor and fetch the rows one by one into your PL/SQL table.
Re: Bulk Collect in Oracle 8i [message #161337 is a reply to message #161286] Fri, 03 March 2006 05:57 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The manual is a bit shady on the use of BULK COLLECT with dynamic SQL. My bet is that it wasn't supported in 8i.

What error did you get?

_____________
Ross Leishman

Previous Topic: library cache latch
Next Topic: Index not being used in Query
Goto Forum:
  


Current Time: Fri Mar 29 05:03:34 CDT 2024