11 Replies Latest reply on Mar 18, 2019 7:19 AM by John_K

    ORACLE error 6502 in FDPSTP

    AB115

      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