Not to be disrespectful, but you need to at least struggle to find the answers yourself before posting here.
On Mon, Dec 14, 2020 at 12:02 PM Muthukumar.GK <muthanku...@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. > > Regards > Muthu > > On Mon, Dec 14, 2020, 11:43 AM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Sunday, December 13, 2020, Muthukumar.GK <muthanku...@gmail.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. >> >>
