Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Call Oracle Function(Call Oracle Function)
Call Oracle Function [message #1060101] Thu, 23 May 2013 06:54 Go to next message
Oliver Baum is currently offline Oliver Baum
Messages: 6
Registered: July 2009
Junior Member
Hi,

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.

My NamedQuery:
@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?

Thanks
Oliver
Re: Call Oracle Function [message #1060306 is a reply to message #1060101] Fri, 24 May 2013 06:23 Go to previous message
Oliver Baum is currently offline Oliver Baum
Messages: 6
Registered: July 2009
Junior Member
I have fixed the problem.

I had an old version of JPA libarys.

Now it works.
Previous Topic:Problems with Eclipselink batching statements
Next Topic:Trying to Marshall/Unmarshall xjc generated classes that don't have a @XmlRootElement annotation
Goto Forum:
  


Current Time: Sat Sep 20 06:11:56 GMT 2014

Powered by FUDForum. Page generated in 0.04457 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software