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

User_7GGBU

Hi Frankie,
Looking at the word doc you responded it looks like you need to actually use the load balancer IP provided in your outputs not the instance IP. Update your hosts file to add the load balancer ip for the url instead:
152.67.106.203 myebscm.ebshol.org
Let me know if that helps.
Quintin Hill - Cloud Engineer, Packaged Apps

Hi Frankie
can you please let us know , if the issue has been resolved ?
regards, Madhusudhan Rao

1 - 2

Post Details

Added on Jul 15 2021
9 comments
947 views