Re: Cursor probs

"RJ" <ridwan.jeena_at_gmail.com> wrote in message news:1161154298.393835.253660_at_k70g2000cwa.googlegroups.com...
> 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..
>

prefix the table name with the schema name.

eg otherschema.thetable

You have to have rights to select.
Jim Received on Wed Oct 18 2006 - 07:49:09 CDT