Hi,
I'm trying to display the clob column on Page Item. but, it shows the below error message:
I've done the following:
1. Created page item with display only.
2. Add plsql returned function into the page item with the below code:
DECLARE
L_CLOB CLOB;
begin
select p_data INTO l_clob from testdel;
:P2_NEW := L_CLOB;
END;
3. But, it shows as error message.
I would like to return more than 4000 characters. But, no success.
Error computing item source value for page item P2_NEW.
ORA-06502: PL/SQL: numeric or value error
Technical Info (only visible for developers)
- is_internal_error: true
- apex_error_code: WWV_FLOW_FORMS.ITEM_SOURCE_ERR
- ora_sqlcode: -6502
- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error
- component.type: APEX_APPLICATION_PAGE_ITEMS
- component.id: 9741193309934933
- component.name: P2_NEW
- error_backtrace:
ORA-06512: at line 5 ORA-06512: at line 7 ORA-06512: at "SYS.DBMS_SQL", line 1707 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1879 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1894 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 799 ORA-06512: at "APEX_050100.WWV_FLOW_FORMS", line 767
- error_statement:
declare function x return varchar2 is begin DECLARE L_CLOB CLOB; begin select p_data INTO l_clob from testdel; :P2_NEW := L_CLOB; END; return null; end; begin wwv_flow.g_computation_result_vc := x; end;