Analytics Software

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!

Expected CHAR got NUMBER

mariitaFeb 4 2015 — edited Feb 4 2015

I'm getting an error (ORA-00932: inconsistent datatypes: expected CHAR got NUMBER) from the formula below. Which part of this formula is expecting a CHAR?

CASE

WHEN "Enrolment - College"."F Language Preferred Measures"."Preferred Language French (#)" = 0 THEN 'All English'

WHEN "Enrolment - College"."F Language Preferred Measures"."Preferred Language English (#)" = 0 THEN 'All French'

ELSE "Enrolment - College"."F Language Preferred Measures"."Preferred Language French (#)" / "Enrolment - College"."F Language Preferred Measures"."Preferred Language English (#)"

END

This post has been answered by Gianni Ceresa on Feb 4 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2015

Added on Feb 4 2015

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #sql

1 comment

2,770 views