ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error

ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

This is my error I’m going to figure out what was wrong and how to fix it.  I’ve already checked all the variables in the sql statement to ensure that they are not being parsed as characters when they are actually numbers.  This error is happening on just one project and I’m not sure why.

When I run the query in Toad for Oracle I don’t get an error, apparently it’s limited to the built in reporting tools withing APEX.

After some investigation this is the solution that I discovered. There appears to be some weakness around the creation of List of Values within Oracle APEX. My query had a field that ultimately was overwritten by a list of values drop-down in APEX’s report writer tool.  Once I altered the query to do the actual field modification within the query.  Once I did that, the report reappeared without error.

This entry was posted in Oracle APEX. Bookmark the permalink.

Leave a Reply