Fetching and updating cursors
You cannot use input host variables to supply SQL keywords or the names of database objects.
An example follows: int emp_number; char temp; VARCHAR emp_name; /* get values for input host variables */ printf("Employee number?
In PL/SQL, you can refer to the most recent implicit cursor as the SQL cursor, which always has attributes such as %FOUND, %ISOPEN, %NOTFOUND, and %ROWCOUNT.
The SQL cursor has additional attributes, %BULK_ROWCOUNT and %BULK_EXCEPTIONS, designed for use with the FORALL statement.
method: they are bound to the connection for the entire lifetime and all the commands are executed in the context of the database session wrapped by the connection.
Cursors created from the same connection are not isolated, i.e., any changes done to the database by a cursor are immediately visible by the other cursors.
You cannot use input host variables to supply SQL keywords or the names of database objects. if an indicator variable is used with a character string, when a value is truncated, the indicator variable is set to the length of the value in the database.