On Tue, Feb 20, 2018 at 10:45 PM, Alban Hertroys <haramrae@xxxxxxxxx> wrote:
> On 20 Feb 2018, at 8:13, Abhra Kar <abhra.kar@xxxxxxxxx> 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.
So What should be the query ---
sess.createSQLQuery("select procedure()").execute();
Something like this?
Thanks
Abhra
