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

2018-02-20 Thread Abhra Kar
On Tue, Feb 20, 2018 at 10:45 PM, Alban Hertroys wrote: > > > On 20 Feb 2018, at 8:13, Abhra Kar wrote: > > > > Hi , > > I have a stored procedure name "procedure()". Which I am > calling by -- > > > > Session sess = (Session)entityManager.getDelegate(); //entityManager is > javax.persi

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

2018-02-20 Thread Alban Hertroys
> On 20 Feb 2018, at 8:13, 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.cr

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

2018-02-20 Thread Abhra Kar
On Tue, Feb 20, 2018 at 9:52 PM, Adrian Klaver wrote: > On 02/20/2018 08:17 AM, Abhra Kar wrote: > >> >> >> On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver > > wrote: >> > > >> >> Please provide me the list email.I don't know about it. >> > > The list email is the

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

2018-02-20 Thread Adrian Klaver
On 02/20/2018 08:17 AM, Abhra Kar wrote: On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: Please provide me the list email.I don't know about it. The list email is the one you used already: pgsql-gene...@postgresql.org I suspect the problem is t

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

2018-02-20 Thread Abhra Kar
On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver 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 > > wrote: >> >> On 02/19/

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

2018-02-20 Thread Adrian Klaver
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 mailto:adrian.kla...@aklaver.com>> wrote: On 02/19/2018 11:13 PM, Abhra Kar wrote: Hi ,           I have a st

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

2018-02-20 Thread Adrian Klaver
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("sele

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

2018-02-19 Thread Abhra Kar
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 t