Oracle MERGE to remote DB with ORA-01008: not all variables bound

Hi,
I am trying to merge a table in a remote database via DBLINK, but I got an error:
in the using() part, I use a subquery from local db tables.

The simple table merge (between tables with the same structure, and no subquery in using part) is fine.

ORA-01008: not all variables bound
ORA-02063: preceding line from DBLINKUSER1

The MERGE statement works in the same database between different schemas.

What should I look into with when I use MERGE pushing data to a remote DB by using bd link ? Is there somebody who has the same problem before?

Thanks a lot,

Hank Received on Wed Jan 11 2006 - 14:38:49 CST