Hi Team,
In Oracle APEX 24.2 If I ran,
DECLARE l_sql VARCHAR2(4000); l_job NUMBER; BEGIN l_sql := 'BEGIN MY_PACKAGE.MY_PROCESS; END;'; l_job := APEX_PLSQL_JOB.SUBMIT_PROCESS( p_sql => l_sql, p_status => 'Background process submitted'); --store l_job for later reference END;
I'm getting,
Error at line 6/14: ORA-06550: line 6, column 14: PLS-00201: identifier 'APEX_PLSQL_JOB.SUBMIT_PROCESS' must be declared ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240200".
What should i need to get this run, Can you please explain.
Thanks,
Pavan