What are exceptions? Where are they handled?

What will be an ideal response?


In PL/SQL, errors are known as exceptions. An exception occurs during the execution of
a program when an unwanted situation arises. The exceptions can occur due to a system
error, a user error, or an application error. When the exception occurs, control of the
current program block shifts to another section of the program known as the exception
section to handle exceptions. If the exception handler part exists, it is performed. If an
exception handler does not exist in the current block, control propagates to the outer
blocks. If the handler is not in any blocks, PL/SQL returns an error and the script stops.

Computer Science & Information Technology

You might also like to view...

In JDK 1.5, analyze the following code.

``` Line 1: Integer[] intArray = {1, 2, 3}; Line 2: int i = intArray[0] + intArray[1]; Line 3: int j = i + intArray[2]; Line 4: double d = intArray[0]; ``` a. It is OK to assign 1, 2, 3 to an array of Integer objects in JDK 1.5. b. It is OK to automatically convert an Integer object to an int value in Line 2. c. It is OK to mix an int value with an Integer object in an expression in Line 3. d. Line 4 is OK. An int value from intArray[0] object is assigned to a double variable d.

Computer Science & Information Technology

Explain why EAP was developed.

What will be an ideal response?

Computer Science & Information Technology

In VBA, programming ________ are statements that document what the code does

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Match each item with the correct statement below.

A. A document that shows the travel schedule of a business person. B. A file that contains the variables to be merged with the main document is the _____. C. Shows suggested revisions in a document. D. A keyboard search uses ________________ to match keywords. E. Contains the text and graphics that remain the same for each version of the merged document. F. Inserted as placeholders at the place where the name, address, and other data will appear in a form letter. G. All the variables for one individual are called a(n) ______. H. A resume in a Word document attached to an e-mail is an example of a(n) ____________.

Computer Science & Information Technology