From: suhong.it on
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

From: Anurag Varma on

What database version(s)?
and what exact sql?

Probably you are looking at a bug.

Anurag