Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NVL and select case when null

metalrayAug 5 2009 — edited Aug 5 2009
Hello,

I am struggling with the fact that my subquery returns null and the update failes.
Altough compiling does not throw an error, using that script in my client applicatio
gives me ORA...cannot update to NULL or something (sorry, not have the error code available right now).

I tried it with the nvl function and a SELCT CASE...WHEN..THEN but both did not help.
It would be great if someone has an idea.

Thanks a lot

here is the code

I noticed that oracle treats empty string '' as null thats why I introduced the dummy keyword 'empty'
This post has been answered by Beijing on Aug 5 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2009
Added on Aug 5 2009
7 comments
6,324 views