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

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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com