"ORA-28267 Invalid NameSpace" with APEX 4.0.1 and WebLogic server
HaakonAug 31 2010 — edited Sep 2 2010Hi 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-