Invalid NameSpace Value when Using DB Link
I am receiving the following error within apex when I try to access data across a database link:
failed to parse SQL query:
ORA-28267: Invalid NameSpace Value
ORA-02063: preceding line from DB_LINK
When I access the same data using a database tool like Toad, I do not get the error.
We are using:
Apex 4.0.1
Clustered WebLogic 10.3.4
APEX_LISTENER_VERSION 1.0.2.238.15.24
Database information
CORE 11.2.0.1.0 Production
NLSRTL Version 11.2.0.1.0 - Production
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
I have a different database link that works just fine, the only difference between the db links that I know of is that the one with the error has select/insert/update/delete and the one that works has select only.
Has anybody ever seen this?
Thanks,
Michelle