Calling Oracle functions from EJB in Seam framework

Question

Hi,

I am using seam framework and struggling to call a Oracle function. In my EJB, I am creating a namedQuery and when I call my entityManager.getResult() I get the following error:

PLS-00222: no function with name 'jjhg' exists in the scope. 

(jjhg is the name of my oracle function)

Please help. This is a bit urgent for me

Answer 1

There are a couple of things which might cause this:

1. JIHG is a procedure rather than a function.
2. JIHG is a private function which has been declared out of scope of the current block.

As you're using a framework to call the program unit I suspect the first explanation is the more likely.