isopenthe isopen yields true if its cursor or


%ISOPEN

The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

 

IF c1%ISOPEN THEN -- cursor is open

...

ELSE -- cursor is closed, so open it

OPEN c1;

END IF;

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: isopenthe isopen yields true if its cursor or
Reference No:- TGS0172712

Expected delivery within 24 Hours