-
SQL> variable jobno number
SQL> exec dbms_job.submit(JOB => :jobno, -
> WHAT => 'ANALYZE_SCHEMAS',-
> NEXT_DATE => trunc(SYSDATE)+1,-
> INTERVAL => 'SYSDATE+1');
BEGIN dbms_job.submit(JOB => :jobno, WHAT => 'ANALYZE_SCHEMAS',
*
ERROR at line 1:
ORA-06550: line 1, column 109:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 131
ORA-06512: at line 1
-
To be more clear cut and paste the entire code of ur pl/sql blcok.
-
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');
