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.

10 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.

Unknown said...

It works.
Thanks.

Anonymous said...

Straight to solution. It works . Thanks!

Marco said...

Thanks !

Inala Rama Krishna Rao said...

Thanks for your research information.

Shekhar Nalawade said...

Very much helpful

Docker Tutorial

 I have listed all the necessary commands of Docker below. In case if any is missing or if any improvement required, please share in comment...