SQL & PL/SQL

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 Value

RRAMar 10 2013 — edited Mar 12 2013

Hi,

I have a Database View created in old database version 10g. We migrated to oracle database 11g(11.2.0.3), however this view is needed to run from db 10g.
By using DBLink, we successfully created view in 11g & showing data nicely. Both views are created in separate Tablespace.

However, while trying to load data in table in jspx page, from JDev 11g , below errors are coming -

java.sql.SQLException: ORA-28267: Invalid NameSpace Value
ORA-02063: preceding line from DB_LINK

We tested successfully in ApplicationModuleTester but error coming while running jspx page.

Issue seems to more relate from database side than application side. Any help will be appreciated.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2013

Added on Mar 10 2013

#11g, #in

9 comments

1,378 views