Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources] نسخه متنی

Lab 11.3 Exercises

11.3.1 Use SQLCODE and SQLERRM

In this exercise, you add a new record to the ZIPCODE table. The original PL/SQL script does not contain any exception handlers. You are asked to add an exception-handling section to this script.

Create the following PL/SQL script:

-- ch11_3a.sql, version 1.0
SET SERVEROUTPUT ON
BEGIN
INSERT INTO ZIPCODE
(zip, city, state, created_by, created_date, modified_by, modified_date)
VALUES (
'10027', 'NEW YORK', 'NY', USER, SYSDATE, USER, SYSDATE);
COMMIT;
END;

Execute the script and answer the following questions: