Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle APEX SQL Command Select Query Returning Error

Jasper TanglibJul 15 2021

Hi,
In Oracle APEX 20.2, I have a table called TC_DATABASE. I wanted to see its data and so I did the usual select query, SELECT * FROM TC_DATABASE, but suddenly it displays the error, as shown below,
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
I think this error has something to do with the data. Since these data are just my tests, I just truncated the table, tried to do the select query again on the now empty table but it still returned the same error. I can still insert data into the table though.
What caused this behavior and how to fix this?
User:

Any idea or suggestion is appreciated!
-Jazz

Comments

Post Details

Added on Jul 15 2021
9 comments
946 views