I have db1 and db2.
db1 has a package.proc1, which uses a merge statement
the object (table1) that it tries to merge is in db 2
i have a public synonym for table1 that points to table1@dblink2db2
when i use merge, i am getting the follwing error...
when i have teh table one in the same db but under different schema i dont have that issue...in that cse there is no dblink involved.
please advice. this could be a sho stopper for my project.
ERROR at line 1:
ORA-01008: not all variables bound
ORA-02063: preceding line from PRST
ORA-06512: at "P_ATE.ACTION_UPDATE", line 6
ORA-06512: at line 2