Why do I have ORA-00904 even when the column is present?

oracle oracle10g ora-00904
Victor picture Victor · Apr 19, 2011 · Viewed 160.4k times · Source

I see an error while executing hibernate sql query.

java.sql.SQLException: ORA-00904: "table_name"."column_name": invalid identifier

When I open up the table in sqldeveloper, the column is present.

The error is only happening in PROD, not in DEV.

What should I check?

Answer

Jon Heller picture Jon Heller · Apr 20, 2011

It could be a case-sensitivity issue. Normally tables and columns are not case sensitive, but they will be if you use quotation marks. For example:

create table bad_design("goodLuckSelectingThisColumn" number);

Related questions

How to use BOOLEAN type in SELECT statement

I have a PL/SQL function with BOOLEAN in parameter: function get_something(name in varchar2, ignore_notfound in boolean); This function is a part of 3rd party tool, I cannot change this. I would like to use this function …

Read More
Using 'case expression column' in where clause

SELECT ename , job , CASE deptno WHEN 10 THEN 'ACCOUNTS' WHEN 20 THEN 'SALES' ELSE 'UNKNOWN' END AS department FROM emp /* !!! */ WHERE department = 'SALES' This fails: ORA-00904: "%s: invalid identifier" Is there a way to overcome this limitation in Oracle 10.2 SQL ? How to …

Read More
ORA-00904: : invalid identifier

I am trying to create a Table in Oracle and getting the error : ORA-00904: : invalid identifier Here is my command. I really can't see any problem in it. Please help me to identify the error. Thanks. CREATE TABLE Sale ( CustomerId …

Read More