Amadeu Cabanilles Amadeu Cabanilles - 1 month ago 9
SQL Question

ORA-00932: Decode BLOB

I have a table with this column:

LOGO BLOB


and making this select

DECODE (pro.holder_hidden,'T', null, com.LOGO) COMPANY_LOGO


I got an error

ORA-00932: inconsistent datatypes: expected CHAR got BLOB
00932. 00000 - "inconsistent datatypes: expected %s got %s"
*Cause:
*Action:

Answer

Does it work for you?

case pro.holder_hidden when 'T' then null else com.LOGO end
Comments