Oracle created PL/SQL that extends some limitations of SQL to provide a more comprehensive solution for building mission-critical applications running on Oracle database.
Use this object to define event handlers that react to the results of the request, as shown in the following example: .
Answer 2: To make it possible for the plch_proc procedure to compile without error, change “AND” to “OR” in the WHEN clause of the exception section.
Because only one exception can be raised at a time in a session, it doesn’t make any sense to allow you to check for two (or more) exceptions in a single handler.
As you move through the records the EOF property is set to false but after you try and go past the last record, the EOF property becomes true.
This works the same in reverse for the BOF property.
If this is not the case, you need to follow the basic SQL tutorial to have a good start.