Exception :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
when running the period close analyzer I got the following message for version 200.3
Exception :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
in side AP_ACCTG_DATA_FIX_PKG.Open_Log_Out_Files
Resolved it by opening the opening the description of BODY AP_Acctg_Data_Fix_PKG and changing as follow:
From:
PROCEDURE Open_Log_Out_Files
(P_Bug_Number IN varchar2,
P_File_Location OUT NOCOPY VARCHAR2) IS
l_log_file VARCHAR2(30); ----- <<== original value
l_out_file VARCHAR2(30); ----- <<== original value
l_file_location v$parameter.value%type;
No_Utl_Dir EXCEPTION;
l_date VARCHAR2(30);