select
category_type_code
bulk collect into list_of_category_type_code
from
category_type@cci;



the above statement in pl/sql gives me this execution error(read the text part only).

01-OCT-03--1025 : ORA-01025: UPI parameter out of range
ORA-02063: preceding line from CCI


I have created the link and it works fine if I am doing any other query from the same database ,but when I am using a table from a different database then it gives me an error.Is it that BULK COLLECT INTO doesnt work when dealing with table from a different database.
thanks
Manohar