Eclipse Community Forums: EclipseLink » Doing an Oracle db query with a PL/SQL Function in where clause

Help

Home

Home » Eclipse Projects » EclipseLink » Doing an Oracle db query with a PL/SQL Function in where clause

Show: Today's Messages :: Show Polls :: Message Navigator

Doing an Oracle db query with a PL/SQL Function in where clause [message #1219563]

Wed, 04 December 2013 16:26

Christophe Pruvost

Messages: 1
Registered: December 2013

Junior Member

Hi all

I would like to do a query like that :

select o from VPdcinfo o where GET_MODULO_FROM_ID(o.id) = :NumModulo

The problem is that my Oracle PL/SQL function "GET_MODULO_FROM_ID" is not supported and generate an error....

An idea please...?

Ty for all

PS : fyi GET_MODULO_FROM_ID runs well using sqlplus... Surprised

)

Report message to a moderator

Re: Doing an Oracle db query with a PL/SQL Function in where clause [message #1719042 is a reply to message #1219563]

Mon, 04 January 2016 16:39

Fabio Higor

Messages: 1
Registered: January 2016

Junior Member

Good afternoon,
I'm going through the same problem, I need to put variables in session and can not. Found a solution?

Report message to a moderator

Re: Doing an Oracle db query with a PL/SQL Function in where clause [message #1719080 is a reply to message #1719042]

Tue, 05 January 2016 01:03

Clovis Wichoski

Messages: 11
Registered: January 2016

Junior Member

Use EclipseLink JPQL extension SQL[1], to encapsulate custom database functions.

[1] https://www.eclipse.org/eclipselink/documentation/2.6/jpa/extensions/jpql.htm#sql

Report message to a moderator

Re: Doing an Oracle db query with a PL/SQL Function in where clause [message #1719376 is a reply to message #1719080]

Thu, 07 January 2016 14:38

Chris Delahunt

Messages: 1239
Registered: July 2009

Senior Member

You might also want to see "FUNCTION" which will allow you to mix JPQL into it: "SELECT o FROM VPdcinfo o WHERE FUNCTION('GET_MODULO_FROM_ID',o.id) = :NumModulo"

https://www.eclipse.org/eclipselink/documentation/2.6/jpa/extensions/jpql.htm#func

[Updated on: Thu, 07 January 2016 14:41]

Report message to a moderator

Previous Topic:	InvalidQuery key [...] exception with CriteriaQuery
Next Topic:	Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 25 23:05:55 GMT 2017

.:: Contact :: Home ::.