Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid NameSpace Value when Using DB Link

MSchafferJun 2 2011 — edited Jun 2 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2011
Added on Jun 2 2011
0 comments
304 views