CODEWITHSUNDEEP
sqloracle-databasehibernatejdbc
sam_evang
sam_evang

Reputation: 71

SQL Error: 904, SQLState: 42000 ORA-00904: : invalid identifier

Can below scenario of duplicate alias lead to an error when executed from JDBC or hibernate:

SQL Error: 904, SQLState: 42000 ORA-00904: : invalid identifier

select * From table_master VW
LEFT OUTER JOIN TABLE(test_func(1, 300)) vw 
ON VW.table_key = vw.function_key

Facing this in production only. It works fine in test environment.

Upvotes: 2

Views: 45926

Answers (3)

JoseJC
JoseJC

Reputation: 770

Verify that the user with which you are executing the query has the necessary grants for the test_func() function.

Upvotes: 0

kolle_86
kolle_86

Reputation: 396

In my case I missed @ManyToOne(fetch = FetchType.EAGER) on that @JoinColumn

Upvotes: 1

Davel_AG
Davel_AG

Reputation: 136

In my case the DB field didn't exist, and it was returning SQL Error: 904, SQLState: 42000 ORA-00904: : invalid identifier

After Creating the field, of course it worked,

Double check those fields and make sure they are matching...

Hope it may give you a clue to find the issue

Upvotes: 4

Related Questions