Please help: ORA-06512 to use DBMS_JOB

[Blu]

CREATE OR REPLACE PROCEDURE ANALYZE_SCHEMAS
AS
type array is table of varchar2(30);
l_users array := array('B2E52_US1', 'B2E52_US2', 'B2E52_US3');
l_junk varchar2(30);
errmsg varchar2(255);

BEGIN

FOR i in 1 .. l_users.count
LOOP
BEGIN

DBMS_UTILITY.ANALYZE_SCHEMA(l_users(i),'COMPUTE');

END;
END LOOP;

END;
/

variable jobno number
exec dbms_job.submit(JOB => :jobno, -
WHAT => 'ANALYZE_SCHEMAS',-
NEXT_DATE => 'trunc(SYSDATE)+1',-
INTERVAL => 'SYSDATE+1');