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!

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

Gaz in Oz

You will need to supply more information.

. sqlcl version

sql -v

or from within sqlcl

show version

. How do you start the bash shell?

. copy/paste how you start bash. (xterm emulator? cmd.exe? Conemu64?...)

. copy/paste how you start sqlcl

Basically, to help you, you need to show us what you are doing, not just tell us.

For example, up-arrow works for me on windows 10 with bash 3.1:

F:\Oracle>bash

bash-3.1$ sql gaz/gaz@xe

SQLcl: Release 17.2.0 Production on Mon Oct 02 17:45:15 2017

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> show version

Oracle SQLDeveloper Command-Line (SQLcl) version: 17.2.0.184.0917

SQL> -- pressing up arrow

SQL> show version

calinm

Hi,

I start using the shortcut on the desktop:

C:\cygwin64\bin\mintty.exe -i /Cygwin-Terminal.ico -

$ java -version

java version "1.8.0_131"

echo $TERM

xterm

$ echo $BASH_VERSION

4.3.46(7)-release

After pressing arrow up 4 times, the cursor goes up 4 lines, as seen in the screenshot

I also tried to start it using cygwin.bat which contains:

@echo off

chdir C:\cygwin64\bin

bash --login -i

this time, arrow up does nothing.

I have nothing in .bash_profile, or any other init scripts.

Thank you,

Calin

1 - 2

Added on Jul 15 2021

#apex, #apex-discussions, #bug, #database, #issue, #oracle

9 comments

970 views

APEX

Oracle APEX SQL Command Select Query Returning Error

Comments

Post Details