Using MERGE Statement in custom adapter


I can run the below SQL fine from TOAD, but when I run it via a wM JDBC 6.5 Custom SQL adapter, the adapter service just hangs (forever!)…

“md5_digest” is just a custom function created in the DB.

Any thoughts?


MERGE INTO emp_md5 USING dual ON (employee_id=‘11111111’)
WHEN MATCHED THEN UPDATE SET md5=md5_digest(‘test’),updated_date=sysdate where employee_id=‘11111111’ AND md5 !=md5_digest(‘test1’)
WHEN NOT MATCHED THEN INSERT (employee_id,md5,created_date)
VALUES (‘11111111’,md5_digest(‘test1’), sysdate)

mod: please remove this thread…