Oracle-error

When I try to run a Crystal report, I get the following message:

a.) "ODBC Error: [Oracle][ODBC]Ora]ORA-00904:invalid column name"

Note: This error message can occur due to multiple reasons - see b.) below

If you have entered additional hardcoded SQL statements to your SQL, they may have double quotes (") around the literal value you are selecting.

Example: AGENCY."AGENCY_NBR" = "G10"

Resolution:

Change the double quotes(") around your literal to single quotes(').

Change to:

AGENCY."AGENCY_NBR" = 'G10'

b.)"ODBC Error: [Oracle][ODBC]Ora]ORA-00904:invalid column name"

or

"ODBC Error: [Oracle][ODBC]Ora]ORA-00933:SQL command not properly ended"

If you are using a left outer join in your Crystal report, you may receive one of the above error messages. Invalid characters may be generated in the SQL for Oracle.

Resolution:

You will need a new version of the following Crystal file installed on your system:

P2SODBC.DLL or PDSODBC.DLL - Version 7.0.100.28

I get this error message when I'm trying to export the database. (ORA-00904)

Point value changed by question poster.

make sure that you are using the same version or a higher version of exp to export the database. oerr returns "%s invalid identifier". You may have mistyped the command.

This question was closed by the author