What are cursor attributes?

• %ROWCOUNT
• %NOTFOUND
• %FOUND
• %ISOPEN

  1 User has rated as useful.

  

Login to rate this answer.

%ROWTYPE - returns number of the rows which are fetched/updated/deleted
%ISOPEN    - returns true if the cursor is open
%FOUND     - returns true if the cursor fetched any row
%NOTFOUND-returns true if the cursor does not fetch any row

  2 Users have rated as useful.

  

Login to rate this answer.

Cursor attributes when appended to the cursor name allow the users to access useful information from the retrieved rows.  After opening a cursor a 'fetch' statement is used to fetch rows from the active set, one at a time.  The following attributes indicate whether fetch statement has failed or succeeded.

• %NOTFOUND  -  evaluates true when no records are found or when 'fetch' fails to return a row.
  
• %FOUND - evalutes true when records are found or when 'fetch' succeeds in returing rows.
  
• %ROWCOUNT - to return number of rows fetched or when 'fetch' returns the number is incremented.
  
• %ISOPEN - evaluates true when cursor is open else false.