Skip to Main Content

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!

empty_blob question

chuckersJul 22 2011 — edited Jul 22 2011
I was going to add some error handling into a procedure, where someone had either not filled a BLOB column in a table, or if they had filled it with empty_blob(). I can't figure out how to test for empty_blob() though ... as I keep getting errors. The tests which failed:
if l_blob = empty_blob() then ... 
and
declare 
  l_test_blob blob := empty_blob();
begin
 ...
  if l_blob = l_test_blob then ... 
Also, I've not been able to find much on what empty_blob() actually accomplishes. If someone has a better link than the really short descriptions I've found so far, it would be really appreciated.

Thanks,
--=Chuck
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2011
Added on Jul 22 2011
7 comments
1,625 views