JOB created, then performed manually error

This is my JOB to create the statement

 begin 
Sys. Dbms_job. Submit (job=& gt; : job, 
What=& gt; 'update fb_p_base dd 
Set the dd. C13=
(select jd 
The from PKGK. Vw_fb_zxjdgx aa 
Where dd. Prj_code=aa. Prj_code 
And chemical set_year=2018 
And the dd. Batch_no=1 
And the dd. Data_type=0); '
Next_date=& gt; 12:45:56 to_date (' 14-11-2017 ', 'the dd - mm yyyy hh24: mi: ss'), 
The interval=& gt; '(SYSDATE + 1)); 
commit; 
The end; 

Bother everybody to help see, where there are problems

CodePudding user response:

And the dd. Data_type=0); 'at the back of the semicolon,

If not yet, will encapsulate the update statement to a stored procedure, and then the job call a stored procedure,

CodePudding user response:

The statements enclosed in the begin end

CodePudding user response:

refer to the second floor sxq129601 response:

encapsulate statements in the begin end

Encapsulated into the begin end of PL/SQL block to also go,

CodePudding user response:

. Look at the PKGK vw_fb_zxjdgx permissions of this content isn't according to given your current user,
In the process and job calls permissions are need to display,

CodePudding user response:

According to authorization,,,