Hi Team
I am trying to use flows for apex with my current apex application . I have created a simple flow with Approval Hierarchy with an User task to create a program . every time i create a program a new instance is created in flows for apex (Working fine) ,But when i try to update the same data it gives me an NO DATA FOUND error.
is_internal_error: false
ora_sqlcode: 100
ora_sqlerrm: ORA-01403: no data found ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2301 ORA-06512: at line 73 ORA-06512: at line 147 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 679 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2262 ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 301 ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC", line 340 ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 1694 ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2781
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 36423526267346130
component.name: Flows for APEX - Complete Step [Plug-in]
error_backtrace:
ORA-06512: at line 73
ORA-06512: at line 147
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 679
ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2262
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2301
ORA-06512: at line 73
ORA-06512: at line 147
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 679
ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2262
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 301
ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC", line 340
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 1694
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2781
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 203
error_statement:
begin declare
function execution
( p_process in apex_plugin.t_process
, p_plugin in apex_plugin.t_plugin
)
return apex_plugin.t_process_exec_result
as
l_result apex_plugin.t_process_exec_result;
--attributes
l_attribute1 p_process.attribute_01%type := p_process.attribute_01;
l_attribute2 p_process.attribute_02%type := p_process.attribute_02;
l_attribute3 p_process.attribute_03%type := p_process.attribute_03;
l_attribute4 p_process.attribute_04%type := p_process.attribute_04;
l_attribute5 p_process.attribute_05%type := p_process.attribute_05;
l_attribute6 p_process.attribute_06%type := p_process.attribute_06;
l_attribute7 p_process.attribute_07%type := p_process.attribute_07;
l_attribute8 p_process.attribute_08%type := p_process.attribute_08;
l_process_id flow_processes.prcs_id%type;
l_subflow_id flow_subflows.sbfl_id%type;
l_dgrm_id flow_processes.prcs_dgrm_id%type;
l_gateway_name flow_objects.objt_bpmn_id%type;
type flow_step_info is record
( dgrm_id flow_diagrams.dgrm_id%type
, source_objt_tag flow_objects.objt_tag_name%type
, source_lane_id flow_objects.objt_objt_lane_id%type
, target_objt_id flow_objects.objt_id%type
, target_objt_ref flow_objects.objt_bpmn_id%type
, target_objt_tag flow_objects.objt_tag_name%type
, target_objt_subtag flow_objects.objt_sub_tag_name%type
, target_lane_id flow_objects.objt_objt_lane_id%type
);
l_step_info flow_step_info;
l_context apex_exec.t_context;
l_idx_process_id pls_integer;
l_idx_subflow_id pls_integer;
l_url varchar2(4000);
begin
--debug
if apex_application.g_debug
then
apex_plugin_util.debug_process
( p_plugin => p_plugin
, p_process => p_process
);
end if;
if (l_attribute1 = 'item') then
l_process_id := apex_util.get_session_state(p_item => l_attribute2);
l_subflow_id := apex_util.get_session_state(p_item => l_attribute3);
elsif (l_attribute1 = 'sql') then
l_context := apex_exec.open_query_context(
p_location => apex_exec.c_location_local_db,
p_sql_query => l_attribute4
);
l_idx_process_id := apex_exec.get_column_position(l_context, 'PROCESS_ID');
l_idx_subflow_id := apex_exec.get_column_position(l_context, 'SUBFLOW_ID');
apex_debug.message('l_idx_process_id '||l_idx_process_id);
apex_debug.message('l_idx_subflow_id '||l_idx_subflow_id);
while apex_exec.next_row(l_context) loop
l_process_id := apex_exec.get_number(l_context, l_idx_process_id);
l_subflow_id := apex_exec.get_number(l_context, l_idx_subflow_id);
end loop;
apex_exec.close(l_context);
end if;
select prcs.prcs_dgrm_id
into l_dgrm_id
from flow_processes prcs
where prcs.prcs_id = l_process_id;
select l_dgrm_id
, objt_source.objt_tag_name
, objt_source.objt_objt_lane_id
, conn.conn_tgt_objt_id
, objt_target.objt_bpmn_id
, objt_target.objt_tag_name
, objt_target.objt_sub_tag_name
, objt_target.objt_objt_lane_id
into l_step_info
from flow_connections conn
join flow_objects objt_source
on conn.conn_src_objt_id = objt_source.objt_id
and conn.conn_dgrm_id = objt_source.objt_dgrm_id
join flow_objects objt_target
on conn.conn_tgt_objt_id = objt_target.objt_id
and conn.conn_dgrm_id = objt_target.objt_dgrm_id
join flow_processes prcs
on prcs.prcs_dgrm_id = conn.conn_dgrm_id
join flow_subflows sbfl
on sbfl.sbfl_current = objt_source.objt_bpmn_id
and sbfl.sbfl_prcs_id = prcs.prcs_id
where conn.conn_dgrm_id = l_dgrm_id
and conn.conn_tag_name = flow_constants_pkg.gc_bpmn_sequence_flow
and prcs.prcs_id = l_process_id
and sbfl.sbfl_id =
Thanks & Regards
Vaibhav