When I used pl/sql to create workflow, I catched the error. What I need to do to fix it?
Thank you!
DECLARE
l_workflow_id NUMBER;
BEGIN
-- Bật debug để ghi nhận log
apex_debug.enable;
-- Gọi workflow và xử lý ngoại lệ
BEGIN
l_workflow_id := apex_workflow.start_workflow(
p_application_id => 259094,
p_static_id => 'TEST_WORKFLOW'
);
DBMS\_OUTPUT.PUT\_LINE('Workflow started successfully with ID: ' || l\_workflow\_id);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error occurred while starting workflow: ' || SQLERRM);
END;
-- Tắt debug
apex_debug.disable;
-- Truy vấn log debug của phiên hiện tại và in ra kết quả
FOR rec IN (
SELECT message, message_timestamp
FROM apex_debug_messages
WHERE session_id = apex_application.g_instance -- ID phiên hiện tại
ORDER BY message_timestamp DESC
) LOOP
DBMS_OUTPUT.PUT_LINE('[' || '] ' || rec.message_timestamp || ' - ' || rec.message);
END LOOP;
END;
------end-------------
Error occurred while starting workflow: ORA-01403: no data found [] 17-FEB-25 02.15.26.331911 AM +00:00 - Exception in "teardown": Error Stack: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APEX_240200.WWV_FLOW_LOG", line 471 ORA-06512: at "APEX_240200.WWV_FLOW_LOG", line 256 Backtrace: ORA-06512: at "APEX_240200.WWV_FLOW_LOG", line 471 ORA-06512: at "APEX_240200.WWV_FLOW_LOG", line 256 ORA-06512: at "APEX_240200.WWV_FLOW_SECURITY", line 4059