Oracle Application Express (MOSC)

MOSC Banner

Running Apex_approval.create_task through procedure

Hello,

I am using Apex to design an application where I need to create Human approval task through a stored procedure.

I noticed, I am able to use the apex_approval.create_task directly through Apex forms but when I try to run this via stored procedure it gives me error:

Error at line 5/38: ORA-20987: APEX - Task definition not found ORA-06512: at "APEX_240200.WWV_FLOW_ERROR", line 1150 ORA-06512: at "APEX_240200.WWV_FLOW_ERROR", line 1608 ORA-06512: at "APEX_240200.WWV_FLOW_APPROVAL", line 3957 ORA-06512: at "APEX_240200.WWV_FLOW_APPROVAL_API", line 66 ORA-06512: at line 8 3. p_company_id varchar2(100); 4. p_user_id varchar2(100); 5. l_task_id number; 6. begin 7. --EXECUTE_SCHEDULE_PROCESS(10301);

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center