2 Replies Latest reply: Jan 30, 2013 11:33 PM by 906930 RSS

    ORA-28267: Invalid NameSpace Value ORA-02063: preceding line from

    906930
      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 !!!!!!!!!