Skip to Main Content
Forums

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.

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

Comments

Post Details

Added on Jul 1 2024
3 comments
422 views