Hi Expert,
I am trying to print custom exception message for the below code but it is not printing .
declare
module_name varchar(50);
obj_name varchar(50);
exp1 exception;
exp2 exception;
begin
select object_name into obj_name from KPA_OBJECTS where object_id=5757;
RAISE exp1;
select mod_name into module_name from module where mod_id=4779;
RAISE exp2;
insert into KPA_VALIDATION_LISTS (validation_rule,enabled_flag,module_id,module_name,object_id,object_name)
values
('test1','Y',6777,module_name,6788,obj_name);
commit;
Exception
WHEN exp1 THEN
raise_application_error (-20002,'please select objectname');
when exp2 then
raise_application_error(-20002,'Please select moduleName');
end;