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!

"ORA-28267 Invalid NameSpace" with APEX 4.0.1 and WebLogic server

HaakonAug 31 2010 — edited Sep 2 2010
Hi all,

I have a page that has a simple query as Region Source. It all worked fine on Apex 3.2 with the iAS mod pl/sql gateway.
Query goes like this:

select servername, a.capture_name, a.status, a.source_database, a.captured_scn, a.applied_scn, b.state_changed_time, b.state
from DBA_CAPTURE@DBLNK_STRM_PADATARP a, V$STREAMS_CAPTURE@DBLNK_STRM_PADATARP b
where a.CAPTURE_NAME (+)= b.CAPTURE_NAME

(it reads out Oracle Streams status over a database link)

After migrating the page to Apex 4.0.1 and WebLogic (Oracle 11g SOA suite) frontend, the Apex page now gives the "ORA-28267 Invalid NameSpace" error for some strange reason.
Apex will now not validate the query in the edit region source page.

I think maybe the problem lies with the WebLogic setup, but exactly what it might be eludes me.

Anyone able to shed any light on this?

Regards,
-Haakon-
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2010
Added on Aug 31 2010
1 comment
466 views