Friday, October 19, 2012

ORA-38104: Columns referenced in the ON Clause cannot be updated

In my case, this error pertains to Oracle Merge query. After 30 minutes of time wastage and a lot of hunting on different forums, I come to know that where and why was my merge query throwing exception.

I was giving multiple criteria in ON clause of merge query, and was also trying to update a column which I have mentioned in ON clause. Once I remove that column from update clause of merge query, it executed successfully.

I hope that this will also works for you.

In case if this post help you, then please comment on it.

Thanks.

6 comments:

Anonymous said...

Thanks.. this was helpful

Anonymous said...

Thank You

Achutha Krishnan said...

Thanks. I was able to update.

Santuane said...

thanks

Syamjith said...

I faced similar issue. One strange observation was Oracle did not throw it to the client application. It did not even insert the record into error table which I had used in my code.

Andy Lam said...

It works.
Thanks.