Oracle APEX 20 -select list error Buffer to Small Ask Question

0
votes

I am using Oracle Apex 20, I created a select list to retrieve data from a view which has a column return a polygon(clob column) (map latitude longitude) look like the picture returned value . If I reduce the returned value it's working file but i don't need that

list error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I guess the question is: How to increase buffer to run this select list? note :- it's working fine in apex 18

2
oracleoracle-apex
Are you saying that that massive JSON object is the return value of an option in the select list? That would be crazy... – Tony Andrews
yes. i think that crazy ,the application already was built with this structure , i am only fix bugs and add some enhancement to this application – jaw-al
Yes, I think the functionality should be redesigned to use APEX properly! – Tony Andrews

2 Answers

0
votes

I'm not sure what "polygon data" means. What is it?

Anyway: as far as I understood the problem, a workaround is to switch to a Pop up list of values (instead of a Select List)

0
votes

If you need the user to select one from a number of possible polygon JSON objects, then you should assign each polygon some sort of key value - e.g. a number, or a code. Your select list should return the number or code, not the whole polygon JSON object.

Once they have selected the code, then you can use it to look up and retrieve the JSON data.