Re: stored procedure call is not working with "select procedure()" option

> On 20 Feb 2018, at 8:13, Abhra Kar <abhra(dot)kar(at)gmail(dot)com> wrote:
>
> Hi ,
> I have a stored procedure name "procedure()". Which I am calling by --
>
> Session sess = (Session)entityManager.getDelegate(); //entityManager is javax.persistent.EntityManager[ Properly Initialise]
> sess.createSQLQuery("select procedure()");

…

> It's not throwing any exception but not executing the procedure.Using oracle query -- sess.createSQLQuery("{ call procedure() }").executeUpdate(); procedure execution is working fine.

Seems to me you are forgetting to execute the query, like in your Oracle example. IIRC, calling execute() is how to execute a statement that returns a ResultSet in Java.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.