New user help: Create and Start instance help

[diegobkc]

Discussed in #778

^{Originally posted by diegobkc December 24, 2024}
Hello, I am following along with one of the introduction tutorials and while trying to create and start a workflow process, I get the error: ORA-06550: line2, column 50: PLS-00201: identifier 'Flow_plugin_manage_instance.execution' must be declared. I have followed all of the steps listed but I cannot find any reason why I would be generating this error. If anyone has seen this before I could use some assistance.

[diegobkc]

is_internal_error: false
original_additional_info: ORA-06550: line 2, column 50: PLS-00201: identifier 'FLOW_PLUGIN_MANAGE_INSTANCE.EXECUTION' must be declared
ora_sqlcode: -6550
ora_sqlerrm: ORA-06550: line 2, column 50: PLS-00201: identifier 'FLOW_PLUGIN_MANAGE_INSTANCE.EXECUTION' must be declared ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 155 ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2676 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240100", line 732 ORA-06550: line 2, column 7: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_SYS_SQL", line 1458 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240100", line 720 ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2015 ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2593 ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 130 ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 436 ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC", line 553 ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 3173 ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 4293
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 43125724092248814
component.name: Start Workflow
error_backtrace:
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1458
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240100", line 720
ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 155
ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2676
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240100", line 732
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1458
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240100", line 720
ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2015
ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2593
ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 130
ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 436
ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC", line 553
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 3173
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 4293
ORA-06512: at "APEX_240100.WWV_FLOW_PROCESS", line 192
error_statement:
begin declare
begin wwv_flow_plugin_api.g_process_exec_result:=flow_plugin_manage_instance.execution(p_process => wwv_flow_plugin_api.g_process,p_plugin => wwv_flow_plugin_api.g_plugin);end;
end;