Question: Consider the following PL/SQL script: SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course_no, description, created_by, created-date, modified_by, modified_date) VALUES (course_no_seq.nextval, 'database development', USER, SYSDATE); COMMIT

 Consider the following PL/SQL script: SET SERVEROUTPUT ON BEGIN INSERT INTO

Consider the following PL/SQL script: SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course_no, description, created_by, created-date, modified_by, modified_date) VALUES (course_no_seq.nextval, 'database development', USER, SYSDATE); COMMIT DBMS_OUTPUT.PUT_LINE ('One course has been added' ); END; Assumptions: All the COURSE table fields have check constraints defined on them indicating that none can be null. 1. Explain why the script does not execute successfully. (3 marks) 2. Add a user-defined exception to the script, so that the error generated by the INSERT statement is handled. Assign the code 2290 to this exception

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!