-
dbms_job not runing
I run this portion of code and i become a error:
declare
v_jobnum number;
v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'')';
v_next_date date :=sysdate;
v_interval varchar2(200) :='sysdate+1/3';
begin
dbms_job.submit
(job => v_jobnum,
what => v_what,
next_date => v_next_date,
interval => v_interval);
commit;
end;
/
Error:
declare
*
ERREUR Ó la ligne 1 :
ORA-06550: Ligne 1, colonne 141 :
PLS-00103: Symbole "END" rencontrÚ Ó la place d'un des symboles suivants :
:= . ( % ;
Symbole ";" a ÚtÚ substituÚ Ó "END" pour continuer.
ORA-06512: a "SYS.DBMS_JOB", ligne 79
ORA-06512: a "SYS.DBMS_JOB", ligne 131
ORA-06512: a ligne 7
in init.ora i already set:
job_queue_processes=36
job_queue_interval=60
What should i do?
-
Add a semicolon:
v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'');';
Ales The whole difference between a little boy and an adult man is the price of toys
-
You have a syntax error. Change:
v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'')';
to
v_what varchar2(2000) :='dbms_utility.analyze_schema(''USER'',''compute'');';
You seem to be missing a semi-colon ( near the end of the line. I ran it and it works.
Dean
Arm yourself with knowledge
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|