Attributes of Cursor are :
%FOUND
:
* Returns NULL if cursor is open and fetch has not been executed
* Returns TRUE if the fetch of cursor is executed successfully.
* Returns False if no rows are returned.
%NOT FOUND
:
* Returns NULL if cursor is open and fetch has not been executed
* Returns False if fetch has been executed
* Returns True if no row was returned
%ISOPEN
:
* Returns true if the cursor is open
* Returns false if the cursor is closed
%ROWCOUNT
:
* Returns the number of rows fetched. It has to be iterated through entire cursor to give exact real count.