Re: Dynamic procedure execution

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dynamic procedure execution
Date: 2020-12-14 06:13:15
Message-ID: CAKFQuwbVZHqZUFzA8i+M=vDcQ4_Wd0+L77r1LTH6GU7xB-X10g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday, December 13, 2020, Muthukumar.GK <muthankumar(at)gmail(dot)com> wrote:

>
> v_query := ' OPEN C1 FOR SELECT * FROM public."Bankdetails"';
>
>
>
> EXECUTE (v_query);
>
>
>
You put the pl/pgsql OPEN command into a string and sent it to the SQL
engine via EXECUTE and the SQL engine is complaining that it has no idea
what you want it to do.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Muthukumar.GK 2020-12-14 06:31:36 Re: Dynamic procedure execution
Previous Message Muthukumar.GK 2020-12-14 05:59:39 Dynamic procedure execution