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.
I have created this blog to place some of important things on it for my personal use and also to help others. Now a days I am doing job as Software Engineer in a company. I have completed my graduation in Computer Science from University of Sindh, Jamshoro, Pakistan.
Subscribe to:
Post Comments (Atom)
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...
-
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...
-
Above problem occur when you have not added a group (of which User try to login) in your local policy login. To resolve the issue, follow t...
-
Dear Readers, I face this problem in a web application build in .aspx. It mainly occurs when you are performing some action with javascrip...
10 comments:
Thanks.. this was helpful
Thank You
Thanks. I was able to update.
thanks
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.
It works.
Thanks.
Straight to solution. It works . Thanks!
Thanks !
Thanks for your research information.
Very much helpful
Post a Comment