Forum Stats

  • 3,873,642 Users
  • 2,266,620 Discussions


Oracle APEX SQL Command Select Query Returning Error

Jasper Tanglib
Jasper Tanglib Member Posts: 74 Red Ribbon


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?

Any idea or suggestion is appreciated!