On Tue, Feb 20, 2018 at 10:45 PM, Alban Hertroys <haramrae@gmail.com> wrote:
> On 20 Feb 2018, at 8:13, Abhra Kar <abhra.kar@gmail.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.