How to declare a while loop which will work until successful completion of the fetch statement in PL/PGSQL

Asked Nov 18 '20 at 09:53

Active Nov 18 '20 at 09:59

Viewed 82 times

I have a procedure in PL/PGSQL where I have declared a cursor now when I tried to execute this loop while(parents%FOUND) where parents is a cursor var it's showing error :

org.postgresql.util.PSQLException: ERROR: operator does not exist: refcursor % boolean Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

edited Nov 18 '20 at 09:59

asked Nov 18 '20 at 09:53

Sugata Kar

This is impossible to answer without seeing your code. – Nov 18 '20 at 09:59
See here [Cursor loop](https://www.postgresql.org/docs/12/plpgsql-cursors.html#PLPGSQL-CURSOR-FOR-LOOP). – Adrian Klaver Nov 18 '20 at 16:25

How to declare a while loop which will work until successful completion of the fetch statement in PL/PGSQL

0 Answers0