Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    1

    Unanswered: "ORA-06502:PL/SQL:numeric or value error: character string buffer too small"

    Hi .

    I am getting this error for my PLSQL
    "ORA-06502:PL/SQL:numeric or value error: character string buffer too small" in ORACLE 10.2.0 installed on Linux.

    My plsql procedure has this segment which fails with the above error.The same plsql procedure works fine in Oracle 9i.

    DECLARE
    l_bid_direction VARCHAR2(1) ;
    BEGIN
    SELECT MAX(bidparam.bid_direction)
    INTO l_bid_direction
    FROM auction_bid_parameters bidparam
    JOIN auction_bid_component bidcomp
    ON bidcomp.bid_parameter_id = bidparam.bid_parameter_id
    AND bidcomp.item_id between 1 and 100 ;
    END;

    But when I run the select query seperately it works fine.
    The same plsql procedure works fine in Oracle 9i too.

    I am getting this issue when I migrated my DB from Oracle 9i to Oracle 10.2.0
    Is there any change in Oracle 10.2.0

    Please let me know

    Thanks in advance
    Binu

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    desc auction_bid_parameters
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •