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()");
procedure is containing some truncate queries like -- EXECUTE('truncate table abc');
It's not throwing any exception but not executing the procedure.Using oracle query -- sess.createSQLQuery("{ call procedure() }").executeUpdate(); procedure execution is working fine.
What's need to be change here.
Thanks and Regards,
Abhra