I want to create a diagram in APEX and use data from Oracle 19c, but have problems to generate correct pl/sql. Here simplified version, with same error:
BEGIN
-- Open JSON object
APEX_JSON.OPEN_OBJECT;
APEX_JSON.WRITE('MY_TEST_DATE', 100);
-- Close JSON object
APEX_JSON.CLOSE_OBJECT;
EXCEPTION
WHEN OTHERS THEN
-- Handle errors in JSON generation
APEX_JSON.OPEN_OBJECT;
APEX_JSON.WRITE('error', 'Unexpected error occurred.');
APEX_JSON.CLOSE_OBJECT;
END;
/
ORA-01403: no data found
ORA-06512: in "APEX_240100.WWV_FLOW_JSON", Line 3074
ORA-06512: in Line 15
ORA-01403: no data found
ORA-06512: in "APEX_240100.WWV_FLOW_JSON", Line 3074
ORA-06512: in Line 8
01403. 00000 - "no data found"
*Cause: No data was found from the objects.
*Action: There was no data from the objects which may be due to end of fetch.
What is the problem here?