--In SQL/PL--

Assignment 4-13: Exception Handling The DoGood Donor application contains a page that allows administrators to change the ID assigned to a donor in the DD_DONOR table. Create a PL/SQL block to handle this task. Include exception-handling code to address an error raised by attempting to enter a duplicate donor ID. If this error occurs, display the message This ID is already assigned. Test the code by changing donor ID 305. (Dont include a COMMIT statement; roll back any DML actions used.)

dd-donor dd pledge dd payment dd dana IDDONOR NOT NULL NUMBERI4) FIRSTNAME VARCHAR2(15 dd project dd status FIGURE 1-9 The DoGood Donor database ERD STATE VARCHAR2(10) NULL NUMBER(6) VARCHAR2(60 PROISTARTDATE IDPAY NOT NULL NUMBER(6) Name Null? IDPLEDGE NOT NULL NUMBER(S NULL NUMBERI2) VARCHAR215) NUMBER3 FIRSTPLEDGE CHAR() dd-donor dd pledge dd payment dd dana IDDONOR NOT NULL NUMBERI4) FIRSTNAME VARCHAR2(15 dd project dd status FIGURE 1-9 The DoGood Donor database ERD STATE VARCHAR2(10) NULL NUMBER(6) VARCHAR2(60 PROISTARTDATE IDPAY NOT NULL NUMBER(6) Name Null? IDPLEDGE NOT NULL NUMBER(S NULL NUMBERI2) VARCHAR215) NUMBER3 FIRSTPLEDGE CHAR()