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.

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

Anonymous said...

Straight to solution. It works . Thanks!

Marco said...

Thanks !

WRITE PERMISSION ON SAMBA DRIVE ON LINUX

Dear Readers, You can find various post on installing SAMBA on Linux. In my post, I am sharing you the method through which you can allow...