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

On Tue, Feb 20, 2018 at 10:45 PM, Alban Hertroys <haramrae@gmail.com> wrote:

> On 20 Feb 2018, at 8:13, Abhra Kar <abhra.kar@gmail.com> 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.