stored procedure call is not working with "select procedure()" option

[Abhra Kar <abhra.kar@xxxxxxxxx>]

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