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

On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 02/20/2018 07:35 AM, Abhra Kar wrote:
>
> Please also reply to list so more people can see and answer.
> Ccing list
>
>>
>>
>> On Tue, Feb 20, 2018 at 8:46 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> On 02/19/2018 11:13 PM, Abhra Kar 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()");
>>
>> 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.
>>
>>
>> More information would help:
>>
>> 1) Postgres version.
>>
>> 2) JDBC driver and version?
>>
>> 3) Any relevant information from the Postgres logs.
>>
>> The forthcoming Postgres version 11 will have stored procedures, but
>> at the moment Postgres has only stored functions.
>>
>>
>
>> Postgres Version -- 9.5
>>
>> JDBC Driver - org.postgresql.Driver
>>
>> JDVC driver version and relavant postgres logs didn't get.
>>
>> Regards,
>> Abhra
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

Please provide me the list email.I don't know about it.

Thanks