Skip to Main Content

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-06512: 在 ORA-06512: 在 "APEX_220200.WWV_FLOW_PAGE

User_7TSHBFeb 18 2023

1.in apex 22.2 ,when i use card to dsiplay clob content ,

1.when i use the sql query; REPLY_CONTENT is clob
SELECT REPLY_CONTENT,DBMS_LOB.GETLENGTH(REPLY_CONTENT) FROM sub_content where sub_id=601
7459
18899

when clob length is 7459, it display card ok
when clob length is 18899, it display card ,report below error:

呈现区域 "查看" 时出错。
请与您的应用程序管理员联系。

技术信息(仅提供给开发人员使用)
is_internal_error: true
apex_error_code: APEX.REGION.UNHANDLED_ERROR
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "APEX_220200.WWV_FLOW_PAGE", line 1932 ORA-06512: 在 "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1655 ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 1120 ORA-06512: 在 "APEX_220200.WWV_FLOW_UTILITIES", line 6942 ORA-06512: 在 "APEX_220200.WWV_FLOW_UTILITIES", line 6895 ORA-06502: PL/SQL: 数字或值错误 ORA-06512: 在 "APEX_220200.WWV_FLOW_UTILITIES", line 6873 ORA-06512: 在 "APEX_220200.WWV_FLOW_SESSION_STATE", line 3444 ORA-06512: 在 "APEX_220200.V", line 130 ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 1032 ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 1304 ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 2445 ORA-06512: 在 "APEX_220200.WWV_FLOW_REGION_NATIVE", line 2362 ORA-06512: 在 "APEX_220200.WWV_FLOW_PLUGIN", line 2766 ORA-06512: 在 "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1023 ORA-06512: 在 "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1584 ORA-06512: 在 "APEX_220200.WWV_FLOW_PAGE", line 1880
component.type: APEX_APPLICATION_PAGES
component.id: 42317000000005
component.name: 查看
error_backtrace:
ORA-06512: 在 "APEX_220200.WWV_FLOW_PAGE", line 1932
ORA-06512: 在 "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1655
ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 1120
ORA-06512: 在 "APEX_220200.WWV_FLOW_UTILITIES", line 6942
ORA-06512: 在 "APEX_220200.WWV_FLOW_UTILITIES", line 6895
ORA-06512: 在 "APEX_220200.WWV_FLOW_UTILITIES", line 6873
ORA-06512: 在 "APEX_220200.WWV_FLOW_SESSION_STATE", line 3444
ORA-06512: 在 "APEX_220200.V", line 130
ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 1032
ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 1304
ORA-06512: 在 "APEX_220200.WWV_FLOW_CARD_REGION", line 2445
ORA-06512: 在 "APEX_220200.WWV_FLOW_REGION_NATIVE", line 2362
ORA-06512: 在 "APEX_220200.WWV_FLOW_PLUGIN", line 2766
ORA-06512: 在 "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1023
ORA-06512: 在 "APEX_220200.WWV_FLOW_DISP_PAGE_PLUGS", line 1584
ORA-06512: 在 "APEX_220200.WWV_FLOW_PAGE", line 1880

3.we setting is as blows:

so my quesiton is can we show the clob content , when length is more than 10000,

any suggestion ?

Comments

Post Details

Added on Feb 18 2023
0 comments
46 views