Cursor probs

Hi all,

I have a cursor that checks the values in a table based on tables in another table in another schema.
e.g - select * from table1 where field1 not in (select field1 from schema2.table2)
when i complile the cursor i get the error "table or view does not exist"
can i not use tables from another schema in a cursor?

thanks in advance.. Received on Wed Oct 18 2006 - 01:51:38 CDT