Ora-00923 Using A CASE WHEN Statement and DataAdapter.Fill
Last updated on JULY 05, 2017
Applies to:Oracle Data Provider for .NET - Version: 10.2.0.1.0 to 10.2.0.2.20
Microsoft Windows (32-bit)
Using a CASE WHEN statement with dataAdapter.Fill fails with the error:
"ORA-00923: FROM keyword not found where expected"
when executing SQL that contains a "CASE" statement.
Example of an invalid query:
SELECT CASE object_name WHEN 'a' THEN 1 END FROM user_objects
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms