bulk collect into list_of_category_type_code
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.