«

Has anybody run into an issue with Hibernate/JPA where an Oracle query
runs fine on SQL Plus but gives an error 'ORA-00900: invalid SQL
statement' when the same query is executed as a native query through
Hibernate/JPA? I can't figure out why the query would run on Oracle
client but fail when Hibernate tries to execute it.

Any ideas?

Thanks.
Puneet

On Jun 11, 10:06 am, puneet.ban...@wipro.com wrote:
> Has anybody run into an issue with Hibernate/JPA where an Oracle query
> runs fine on SQL Plus but gives an error 'ORA-00900: invalid SQL
> statement' when the same query is executed as a native query through
> Hibernate/JPA? I can't figure out why the query would run on Oracle
> client but fail when Hibernate tries to execute it.
>
> Any ideas?
>
> Thanks.
> Puneet

Alright, it was a silly mistake. I was using 'createNativeQuery'
instead of 'createNamedQuery'.

Puneet