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