I'm going mad with an odd compilation error:

When I try and compile a procedure it fails with ORA-00942: table or view does not exist. The table in question (organisation) is on a remote database and the synonym is a private one. The db link used connects as the owner of ORGANISATION on the remote database and is a private one. I can also do a select count(*) from the table in an SQL Plus session:

Code:
SQL> select count(*) from ORGANISATION;

  COUNT(*)
----------
        73
But yet the procedure doesnt seem to be able to see the remote table???? Confused!
Oh - both local and remote databases are 9.2.0.4 on HPUX