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