Skip to main content


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 BaumFriend
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

Report message to a moderator

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 BaumFriend
Messages: 6
Registered: July 2009
Junior Member
I have fixed the problem.

I had an old version of JPA libarys.

Now it works.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 21:29:44 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly