Hi
I am not able to implement bulk collect feature on a cursor that retrieves data using DB links.
I get the error: UPI parameter out of range


Here's the simple code I tried to execute.

declare
CURSOR c1 is
SELECT col1 from table1@dblinkname;
type tDate is table of Date;
myDates tDate;
begin
OPEN c1;
FETCH c1 BULK COLLECT INTO myDates;
CLOSE c1;
end;

Any pointers on resolving this would be appreciated.

Regards
Ramya