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

Previous Topic:	ExpressionBuilder is null when there are concurrent request
Next Topic:	Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 06 14:30:20 GMT 2015

.:: Contact :: Home ::.