hi am having this error when calling another procedure in my key-comit procedure
PROC_employee_DESC(PRAMA1,
PRAMA2,
PRAMA3,
PRAMA4);
this iS the procedure giving error how can i handle that exception is there a better way
PRAMA1=1205478557854786 or 18AAAA4578953568
PROCEDURE PROC_employee_DESC (PRAMA1 in out varchar2,
PRAMA2 in out varchar2,
PRAMA3 out varchar2,
PRAMA4 out varchar2) IS
BEGIN
DECLARE
wrk_param1 NUMBER(11);
wrk_param2 VARCHAR2(8);
wrk_err_param_msg VARCHAR2(80);
wrk_param VARCHAR2(7);
wrk_pram3 VARCHAR2(200);
wrk_param4 VARCHAR2(1);
wrk_err_param5 VARCHAR2(1);
wrk_param6 NUMBER(2);
wrk_param7 hr.employee%type;
wrk_param8 VARCHAR2(1);
wrk_param9 VARCHAR2(1);
wrk_param10 VARCHAR2(3);
wrk_param11 VARCHAR2(1);
wrk_param12 VARCHAR2(2);
wrk_param13 NUMBER(11,2);
wrk_param14 VARCHAR2(1);
wrk_param15 VARCHAR2(1);
wrk_param16 VARCHAR2(1);
wrk_param17 VARCHAR2(1);
wrk_param18 VARCHAR2(1);
wrk_param19 VARCHAR2(1);
wrk_param20 VARCHAR2(1);
wrk_param21 VARCHAR2(80);
wrk_param22 varchar2(16);
wrk_date_param1 DATE;
wrk_name_param VARCHAR2(1);
struc_prama varchar2(1);
pref_param1 varchar2(1);
mit_param2 varchar2(1);
crit_param3 varchar2(1);
param_ind varchar2(1);
param_cde varchar2(1);
pram_mtl_param varchar2(1);
itm_param1 varchar2(1);
itm_param2 varchar2(1);
ets_param123 varchar2(1);
wrk_param131 varchar2(2);
wrk_paream12 varchar2(1);
BEGIN
-- message('CALLINGSTORE');
VALIDATION\_2
(wrk\_param1,
PRAMA1,
wrk\_date\_param1,
PRAMA2,
wrk\_pram3,
wrk\_param4,
wrk\_err\_ind,
wrk\_err\_cde,
wrk\_err\_param\_msg,
wrk\_com\_cde,
wrk\_param8,
wrk\_itm\_stat\_cde,
wrk\_param10,
wrk\_param11,
wrk\_param12,
wrk\_param13,
wrk\_param14,
wrk\_param15,
wrk\_param16,
wrk\_param17,
wrk\_param18,
wrk\_lsar\_ws\_item,
wrk\_param20 ,
wrk\_param21,
struc\_prama,
pref\_param1,
mit\_param2,
crit\_param3,
param\_ind,
param\_cde,
pram\_mtl\_param,
itm\_param1,
itm\_param2,
ets\_param123,
wrk\_param131,
wrk\_paream12);
IF wrk_err_param5= 'Y' THEN
PRAMA3 := wrk_err_ind;
PRAMA4 := wrk_err_param_msg;
message(PRAMA4);
raise form_trigger_failure;
ELSE
PRAMA2 := wrk_pram3;
END IF;
END ;
END;