Eclipse Community Forums: EclipseLink

Home » Eclipse Projects » EclipseLink » Call Oracle Function(Call Oracle Function)

Thu, 23 May 2013 02:54

Eclipse User

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 02:23

Eclipse User

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:

-=] Back to Top [=-

Current Time: Thu Jul 24 22:56:20 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter