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_sqlerrm: ORA-06502: PL/SQL: numeric or value error

sharatsinghJul 1 2024

I am getting this error in Oracle Apex. I am using Apex 23.

I am trying to display two images using the following code:

<img src="data:' || j.mime_type || ';base64, ' || apex_web_service.blob2clobbase64(j.image) || '"></div>';

It is working with one image but when I try to use two images, the below error cropped up. Anyone has solution for this?

Technical Info (only available for developers)

is_internal_error: true
apex_error_code: APEX.REGION.UNHANDLED_ERROR
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value errorORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1999 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647 ORA-06512: at line 685 ORA-06512: at line 685 ORA-06512: at line 701 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2164 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810 ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 267 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 312 ORA-06512: at "APEX_230200.WWV_FLOW_REGION_NATIVE", line 318 ORA-06512: at "APEX_230200.WWV_FLOW_REGION_NATIVE", line 2506 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3163 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1106 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1635 ORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1947
component.type: APEX_APPLICATION_PAGES
component.id: 100000001565
component.name: Report 360 Class XI and Class XII
error_backtrace:ORA-06512: at line 685 ORA-06512: at line 685 ORA-06512: at line 701 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2164 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810 ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607 ORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1999 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1706 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2647 ORA-06512: at line 685 ORA-06512: at line 685 ORA-06512: at line 701 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2164 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230200", line 810 ORA-06512: at "APEX_230200.WWV_FLOW_DYNAMIC_EXEC", line 2607 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC_PLSQL", line 267 ORA-06512: at "APEX_230200.WWV_FLOW_CODE_EXEC", line 312 ORA-06512: at "APEX_230200.WWV_FLOW_REGION_NATIVE", line 318 ORA-06512: at "APEX_230200.WWV_FLOW_REGION_NATIVE", line 2506 ORA-06512: at "APEX_230200.WWV_FLOW_PLUGIN", line 3163 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1106 ORA-06512: at "APEX_230200.WWV_FLOW_DISP_PAGE_PLUGS", line 1635 ORA-06512: at "APEX_230200.WWV_FLOW_PAGE", line 1947

Added on Jul 1 2024

3 comments

553 views