1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Ora-06502: pl/sql: numeric or value error: character string buffer too small in package hr_objective

Discussion in 'Oracle HRMS & Payroll' started by Maya, Sep 2, 2015.

  1. Maya

    Maya Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    Hi,

    When I create an objective , I am getting the below error message.

    ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package hr_objectives_swi Procedure create_objective

    Did anybody face such an issue? how to fix this problem?

    I have attached a screen shot of the page.

    Regards
    Maya
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    Provid here source code of your package ...

    PL/SQL TYPE

    For example :
    Code (SQL):
    DECLARE
      c VARCHAR2(3 CHAR);
    BEGIN
      c := 'abc  ';
    END;
    /
    DECLARE
    *
    ERROR at line 1:
    ORA-06502: PL/SQL: NUMERIC OR VALUE error: CHARACTER string buffer too small
    ORA-06512: at line 4
     
    Last edited: Sep 2, 2015
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
  4. Maya

    Maya Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
     
  5. Maya

    Maya Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Ok.

    Checking...

    I will let you know once I find it.

    Also let us know the full navigation of create objective in appraisal?

    In which resp?
     
  7. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    in processing unit of exceptions add dbms_utility.format_error_backtrace call

    for example(only for test) :
    Code (SQL):
    DECLARE
      v_test varchar2(3 CHAR);
      PROCEDURE prc_test (p varchar2)
      AS
      BEGIN
          v_test := v_test ||p;
      END;      
    BEGIN
        prc_test('a');
        prc_test('b');
        prc_test('c');
        prc_test('d');
    exception WHEN others THEN dbms_output.put_line(dbms_utility.format_error_backtrace());
    END;    
    /
     
    Last edited: Sep 2, 2015
  8. Maya

    Maya Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
     

    Attached Files:

  9. Maya

    Maya Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    I have uploaded the step by step screen shot of the navigation till the point at which the error occurs.
     
  10. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    I have checked, but no idea.

    We don't have standard appraisals to check.

    Just try by giving small objective name ex: Test.

    Also you gave start date as 01-Jan-2015. is that manually given value or drop down selected value?

    If possible change the format and check.
     
  11. Maya

    Maya Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    I tried with small names but of no use.

    Thanks , I will try other options.