PL/SQL Package Error
I have written a package.But am getting following error while executing the package.
[code]
SQL> SQL> BEGIN ODS.PCK_GRDR_MAIL.GRDR_AM02 (500,'FRENCH'); END;
*
*
ERROR at line 1:
ORA-20002: unable to send the mail.ORA-06502: PL/SQL: numeric or value error:
character string buffer too small
ORA-06512: at "MBS.PCK_GRDR_MAIL", line 6303
ORA-06512: at line 1
[/code]
the line 6303 is defined in an exception ( Marked in Bold red letters in the following) .
WHEN utl_smtp.transient_error THEN count_retry := count_retry -1; IF count_retry > 1 THEN PCK_GRDR_MAIL.GRDR_AM02(count_retry,plang); ELSE raise_application_error