Forum Stats

  • 3,768,296 Users
  • 2,252,772 Discussions
  • 7,874,520 Comments

Discussions

Oracle APEX SQL Command Select Query Returning Error

Jasper Tanglib
Jasper Tanglib Member Posts: 67 Green Ribbon

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?



Any idea or suggestion is appreciated!

-Jazz

Answers