> On 20 Feb 2018, at 8:13, Abhra Kar <[email protected]> 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.
