Postgres Pro
Downloads
Home   >   mailing lists

stored procedure call is not working with "select procedure()" option - Mailing list pgsql-general

From Abhra Kar
Subject stored procedure call is not working with "select procedure()" option
Date
Msg-id CAFNULEcotbRuGwe0vKo2fb0_qzp6pcG-BdC1CuvdpJne2cT38Q@mail.gmail.com
Whole thread Raw
Responses Re: stored procedure call is not working with "select procedure()"option  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: stored procedure call is not working with "select procedure()"option  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: George Neuner
Date:
Subject: Re: Connection loosing at some places - caused by firewall
Next
From: Laurenz Albe
Date:
Subject: Re: Performance issues during backup