Skip to Main Content

Java Development Tools

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 ORA-02063: preceding line from

906930Jan 30 2013 — edited Jan 31 2013
HI,

I have problem with calling procedure from 11g database to 10g database.

I created dblink on 11g which connects to remote database 10g and my procedure is inserting to remote database using that link.

this is my dynamic sql :

sql_stmt := 'INSERT INTO BATS.AUTO_TAX_REGISTRIES@'||offname||' ) values('sdfsfsdfsdfs');

EXECUTE IMMEDIATE sql_stmt

when I exucute it from editer it works fine and good
but when I call it programatically (click button) it gives me ORA-28267: Invalid NameSpace Value ORA-02063: preceding line from offname error.

Any suggestion !!!!!!!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2013
Added on Jan 30 2013
2 comments
488 views