E-Business Suite

Hello All,

we are getting

ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at line 1

Procedure:

CREATE OR REPLACE PROCEDURE p_test1 (p_in_report_name      IN     VARCHAR2,

                                     p_in_responsibility   IN     VARCHAR2,

                                     p_in_email            IN OUT CLOB)

IS

   l_exc_custom_exception   EXCEPTION;

   l_chr_attachment_name    VARCHAR2 (100);

   l_chr_email_body         VARCHAR2 (2000);

   l_in_email               CLOB;

BEGIN

   l_in_email := 'abc@google.com' || ',' || 'def@google.com';

   p_in_email := p_in_email || l_in_email;

   IF p_in_report_name = 'Report1'

   THEN

      l_chr_email_body := 'Details of the report';

      l_chr_attachment_name := 'Report1';

   END IF;

EXCEPTION

   WHEN l_exc_custom_exception

   THEN

      DBMS_OUTPUT.put_line ('User Defined Exception => ' || SQLERRM);

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line (

            'Error while submitting request for Error While running email program. Error=> '

         || SQLERRM);

END p_test1;

Error:

ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at line 1

please suggest.

Thanks