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

From: Abhra Kar <abhra(dot)kar(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: stored procedure call is not working with "select procedure()" option
Date: 2018-02-20 07:13:34
Message-ID: CAFNULEcotbRuGwe0vKo2fb0_qzp6pcG-BdC1CuvdpJne2cT38Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-02-20 08:02:28 Re: Performance issues during backup
Previous Message George Neuner 2018-02-20 05:54:05 Re: Connection loosing at some places - caused by firewall