I have an Oracle 11 database on a development server. I'm trying to execute a stored procedure:
declare
date_start varchar2(15);
date_end varchar2(15);
begin
Fecha_inicio := '01/01/2014';
Fecha_fin := '01/01/2016';
FCBK.PKG_PACKAGE.Generate(Fecha_inicio,Fecha_fin);
end;
If I execute the procedure from SQL Developer or from SQL*Plus on my personal Windows machine, the procedure has no problem.
If I execute the procedure from SQL*Plus in the development server (IBM AIX Machine), the procedure ends with this error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Problem solved. Was a internal error of the package. Thanks for all the answers.