Return
-
Title
Getting "Found: Expecting: (" for statement with dblink in the Editor -
Description
When running the following statement...
MERGE INTO table1 t1USING sys.table2@dblink t2ON (t1.col1 = t2.col1)WHEN MATCHEDTHENUPDATE SET t1.col2 = t2.col2WHEN NOT MATCHEDTHENINSERT ( t1.col1, t1.col2)VALUES (t2.col1, t2.col2);it is failing on the "t2" assignment to the sys.table2@dblink t2 table. It's throwing a syntax error"Found `t2`: Expecting: ("It doesn't like the dblink in the merge. This is not a problem in v12.10.For some users it will throw an error, not allowing the statement to be executed. For other users it will just have the row marked in the gutter as having an error and the user is able to execute it.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.