| Bulk Collect in Oracle 8i [message #161286] |
Fri, 03 March 2006 01:19  |
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 #161337 is a reply to message #161286] |
Fri, 03 March 2006 05:57  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
