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!

ORA-06502: character string buffer too small error when importing in the Data Load

Javier PAug 16 2020 — edited Aug 18 2020

Hi All,

In Apex 20.1

Am having this error when importing a table a the data load page:

3.42211	0.00005	CGI: PATH_INFO = /wwv_flow.accept	9	0%
3.42216	0.00025	POST https://infopro1.maxapex.net/apex REMOTE_ADDR=127.0.0.1 REMOTE_USER=APEX_PUBLIC_USER APEX_LISTENER_VERSION=19.4.6.r1421859 REFERER=https://infopro1.maxapex.net/apex/f?p=100:180:11774742961661::::: HTTP_COOKIE=infoproconsultingllc-_zldp=n7NREUi7pC0CpDOkiX25xufcr3W6vcf4Qb%2FPPQ%2F4RCoVuZtiCXs3h4X2hWlQHuDvodoRkLyJC2Y%3D	9	0%
3.42240	0.00003	APEX Version=20.1.0.00.13 SID=28 USER=APEX_PUBLIC_USER INSTANCE=1	9	0%
3.42243	0.00032	Hiding error additional_info, as it contains ORA error message: ORA-06502: PL/SQL: numeric or value error: character string buffer too small	1	0%
3.42275	0.00004	Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small	1	0%
3.42279	0.00004	- additional_info: ORA-06502: PL/SQL: numeric or value error: character string buffer too small	4	0%
3.42284	0.00004	- display_location: INLINE_IN_NOTIFICATION	4	0%
3.42288	0.00004	- is_internal_error: false	4	0%
3.42292	0.00003	- is_common_runtime_error: false	4	0%
3.42295	0.00004	- ora_sqlcode: -6502	4	0%
3.42299	0.00003	- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APEX_200100.WWV_FLOW_COLLECTION", line 3606 ORA-06512: at "APEX_200100.WWV_FLOW_DATA_UPLOAD", line 889 ORA-06512: at "APEX_200100.WWV_FLOW_PROCESS_NATIVE", line 1027 ORA-06512: at "APEX_200100.WWV_FLOW_PROCESS_NATIVE", line 1233 ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 2586	4	0%
3.42302	0.00003	- error_backtrace: ORA-06512: at "APEX_200100.WWV_FLOW_COLLECTION", line 3606 ORA-06512: at "APEX_200100.WWV_FLOW_DATA_UPLOAD", line 889 ORA-06512: at "APEX_200100.WWV_FLOW_PROCESS_NATIVE", line 1027 ORA-06512: at "APEX_200100.WWV_FLOW_PROCESS_NATIVE", line 1233 ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 2586 ORA-06512: at "APEX_200100.WWV_FLOW_PROCESS", line 203	4	0%
3.42305	-	- component: APEX_APPLICATION_PAGE_PROCESS Parse Uploaded Data (11343053055318509)	4	0%

1 - 13

The problem is that I am having a field with a length larger than the target field.

Is there a way I can determine which column of the collection is having the problem? can I see the collection the data load page is processing?

or be able to see which line of the table that am importing is the problem?

Thanks for the help!

This post has been answered by Keyser on Aug 17 2020

Jump to Answer

Added on Aug 16 2020

#apex-discussions

12 comments

3,298 views