Oracle 9i Merge Command Problem
Posted on 2004-08-10
Hi I'm trying to use the merge command but have encountered a problem which does not seem to make sense. I am running the following code:
merge into dest
on (dest.client_number = src.nclient)
when matched then
dest.client_number = src.nclient
when not matched then
when trying to run it I get the following error:
ORA-00904: "DEST"."CLIENT_NUMBER": invalid identifier
Now this table exists and the user I am using is the owner of the table so I can't understand what's wrong. Any ideas?
The version of Oracle I am using is 22.214.171.124.0.