|Call Oracle Function [message #1060101]
||Thu, 23 May 2013 02:54
| Oliver Baum
Registered: July 2009
I want to call the ORACLE database FUNCTION "TO_DATE" with a NamedQuery.
In the documentation I found, that I have to use FUNCTION to call specific database functions.
@NamedQuery(name="useFunction",query="select a from TDatum a where a.datum = FUNCTION('TO_DATE','2013/12/11','yyyy-mm-dd')")
But I always get an "Syntax error parsing" error.
Can somebody help me?
Powered by FUDForum
. Page generated in 0.02506 seconds