|Top Previous Next|
Implicit Cursors, i.e. the ones that are not declared.
Basically implicit cursor is an Embedded SQL statement. SELECT, INSERT, UPDATE and DELETE could be used. Since implicit cursor works with individual variables only, the select statement should return one and only one row. It is similar to Progress FIND.
It is good practice to check that SELECT returns one row only in exception handling, like we do “IF NOT AVAILABLE customer” in progress.