Toad World® Forums

Cursor folding does not close SQL Statement with UNION

If you have a cursor with union statements

FUNCTION fk_sqlnav_cursor_folding_union
RETURN BOOLEAN IS
CURSOR crUnion IS
SELECT ‘A’ FROM DUAL
UNION ALL
SELECT ‘B’ FROM DUAL;
BEGIN
RETURN FALSE;
END;

folding does only close the first select part, see screenshot:
union_cursor_after_folding.png

Hi Torsten,

Thanks for your feedback, we have created a new story(SQLNAV-1928) for it, thanks.

Regards

Alan