dml 구현에서 Exception

S HR> @empInsertTest

begin

*

ERROR at line 1:

ORA-02291: integrity constraint (HR.FK_EMP) violated - parent key not found

ORA-06512: at "HR.EMPINSERT", line 13

ORA-06512: at line 2

empInsert 에 아래와 같이 추가

exception

        when others then

                dbms_output.put_line(SQLERRM);

                dbms_output.put_line(SQLCODE);

                return null;

S HR> @empInsert

S HR> @empInsertTest =>  에러 메시지, 에러 번호 확인 후.. 아래와 같이 수정

exception

        when others then

                if SQLCODE=-2291 then

                        dbms_output.put_line('no Fk.err');

                        return null;

                end if;

S HR> @empInsertTest

no Fk.err

PL/SQL procedure successfully completed.