Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Doing an Oracle db query with a PL/SQL Function in where clause
Doing an Oracle db query with a PL/SQL Function in where clause [message #1219563] Wed, 04 December 2013 11:26
Christophe Pruvost is currently offline 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)
Previous Topic:ExpressionBuilder is null when there are concurrent request
Next Topic:Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException
Goto Forum:
  


Current Time: Wed Jul 23 14:14:38 EDT 2014

Powered by FUDForum. Page generated in 0.01996 seconds