Unanswered: modified column size still buffer small error
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))
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.