ORA-28267: Invalid NameSpace Value ORA-02063: preceding line from
906930Jan 30 2013 — edited Jan 31 2013HI,
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 !!!!!!!!!