Oracle Database Discussions

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!

Inconsistent datatypes: expected CHAR got NUMBER...

526844Feb 25 2007 — edited Feb 25 2007

I am trying to run the following statement and get an error "ORA-00932: inconsistent datatypes: expected CHAR got NUMBER":

SELECT UNIQUE ((CASE WHEN AF.asset_flow_type IS NULL THEN decode(sum(3),0,NULL, sum(4)) ELSE 11 END)) * NULLIF (SUM (asset_flow_amount), 0) from O_ASSET_FLOW AF where AF.asset_flow_type = 39

Any suggestions? Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2007

Added on Feb 25 2007

#general-database-discussions

2 comments

876 views