Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

PRAGMA exception_init(e_errp,-00947) is not working for the error code

set serveroutput on;
DECLARE
e_errp exception;
PRAGMA exception_init(e_errp,-00947);
begin
insert into emp
values('263100001',null);
exception
when e_errp then
dbms_output.put_line('Hiiiii---%s: invalid identifier');
end;

Comments
Post Details
Added on Feb 15 2024
5 comments
127 views