Home > mailing lists

Thread: Check ref cursor

From

Yambu

Date:

31 May 2021, 17:37:57

Hello

How do i check if ref cursor is pointing to empty data?

regards

From

Pavel Stehule

Date:

31 May 2021, 18:39:29

po 31. 5. 2021 v 16:38 odesílatel Yambu <hyambu@gmail.com> napsal:

Hello

How do i check if ref cursor is pointing to empty data?

you can use FETCH command, and check variable FOUND

FETCH xx INTO var;

IF NOT FOUND THEN ...

Regards

Pavel

regards