On Monday, December 14, 2020, David G. Johnston <
david.g.johnston@gmail.com> wrote:
On Sunday, December 13, 2020, Muthukumar.GK <muthankumar@gmail.com> wrote:
Hi David,
As I am not bit Clea, let me know what I have to do. If possible, please re- write my program.
Like the SQL executor, I have no idea what you are trying to do there. Neither the text variable, nor the cursor, nor plpgsql for that matter, provide any benefit to executing “select from table”.
That said, kf you read the “see also” part of the FETCH documentation you will see that DECLARE is the SQL way to dpecify a cursor, not OPEN.
David J.