开发公司根据业务的需要，在本地创建了大量的使用dblink方式去访问远程数据库的数据的SYNONYM（同义词），其实，本地业务用户通过dblink可以访问远程数据库的同义词，如：select * from a.table@dblink ，这样是可以访问的，但是，不幸的是，将同义词放在PROCEDURE里就不行，编译不过去，报错PL/SQL:ORA-04063.

metalink给出了答案:

[@more@]

SELECT From a VIEW in a READ ONLY Database Using a DATABASE LINK Within A CURSOR LOOP Fails With ORA-06550 ORA-04063 PLS-00341 PLS-00364 [ID 358708.1]

Applies to:
PL/SQL - Version 8.1.7.0 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Feb-2012***

Symptoms
Using a DATABASE LINK to connect to a READ ONLY Database to SELECT data from a VIEW fails by
Oracle 8iR3(8.1.7.x)

ORA-04052 error occurred when looking up remote object '

end loop;
end;
/

returns following expected

Output

ERROR at line 3:
ORA-06550: line 3, column 15:
PL/SQL: ORA-04063: view "SCOTT.X_VIEW" has errors
ORA-06550: line 3, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 2, column 8:
PLS-00341: declaration of cursor 'C_USER_OBJECTS' is incomplete or malformed
ORA-06550: line 4, column 16:
PL/SQL: Item ignored
ORA-06550: line 8, column 29:
PLS-00364: loop index variable 'R_USER_OBJECTS' use is invalid
ORA-06550: line 8, column 8:
PL/SQL: Statement ignored
Cause
This is expected behavior in all versions, since code need to be created on the remote READ ONLY Database, for

each time issued a new version need to be created, which cause the problem.

There is an Enhancement Request raised for this in
Bug 2033385 SELECT FROM A VIEW IN A READ-ONLY DB USING A DBLINK WITHIN A CURSOR LOOP FAILS

Solution
Create the VIEW on local Database.

解释一下上面的文字:

由于ORACLE9.2.0.x版本的BUG 2033385，造成了此次报错.

解决方法是使用视图替代同义词.

我们根据metalink描述，给了开发人员建议，将procedure里面所有使用同义词访问远程数据库的，使用创建视图的形式（也带dblink）远程访问数据库，解决这个问题。

ITPub博客

PL/SQL:ORA-04063错误解决方法

最新文章