Some Additional Info:
Explicit cursor attributes
There are four cursor attributes used in Oracle:
- cursor_name%Found
- cursor_name%NOTFOUND
- cursor_name%ROWCOUNT
- cursor_name%ISOPEN
Implicit cursor attributes
Implicit Cursors are prefixed by the word SQL:
- SQL%Found
- SQL%NOTFOUND
- SQL%ROWCOUNT
- SQL%ISOPEN
- SQL%BULK_ROWCOUNT
Cheers!