Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    82

    Unanswered: modified column size still buffer small error

    Hi,
    I was getting the following error message:
    ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    in a column of varchar2(16) where I tried to insert data more than 16 characters so obviously i altered the column and increased the size to 128 and still I get that same error. What is rather strange is that if I remove one letter from the data and then try then it works even though the size of the data is just 17 characters. It seems to me that the modify command has not taken effect, even though the column size in db shows as 128. I had used the following command to change the size:

    alter table <tableName> modify (<columnName> varchar2(128))

    So whts the problem??

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    This is NOT an SQL error, it is rather a PL/SQL error. That being said, it doesn't matter if you change your column's size in SQL (unless you where anchoring the variable type from within PL/SQL), you must change the variable definition down to PL/SQL as well.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Could you post table description and actual insert statement?

  4. #4
    Join Date
    Aug 2005
    Posts
    82
    thnxs for ur help guys, but I had to change one of the procedures as well that was storing in the value of that column and so now it works.

Posting Permissions

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