Amadeu Cabanilles Amadeu Cabanilles - 1 year ago 191
SQL Question

ORA-00932: Decode BLOB

I have a table with this column:


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"

Answer Source

Does it work for you?

case pro.holder_hidden when 'T' then null else com.LOGO end
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download