Declare
Jobno1 int.
The begin
Dbms_job. Submit (jobno1 - job number
'sp_lcn5; ', - execute a stored procedure, '; Don't leave out
'Sysdate - the next execution time
"' - each time interval, the interval to day
);
Commit;
end;


The create or replace procedure sp_lcn5
Is
The begin
CTL. Sp_drop_table (' etl ', 'test5');
The execute immediate 'create table etl. Test5 as
Select * from CTL. Lcn_bak ';

The end;




Don't know why, suddenly this error, until the same code is no problem, ask everybody to help see, urgent urgent!!!

CodePudding user response:

Dbms_job. Submit (jobno1 - job number


Where did you perform?

CodePudding user response:

reference 1st floor wmxcn2000 response:

dbms_job. Submit (jobno1, - the job no.


Where did you perform?

I'm so,

CodePudding user response:

You here at each time interval, the try

'sysdate + 1' - every time interval, the interval to day



In addition, the stored procedure you have no problem, right?

CodePudding user response:

No problem if the stored procedure
The JOB can be created using the graphical interface

CodePudding user response:

The

reference 3 floor wmxcn2000 response:

you here at each time interval, add the try

'sysdate + 1' - every time interval, the interval to day



In addition, the stored procedure you have no problem, right?

Or not, there is no question of the stored procedure, the execution of this before I can actually, now this kind of mistake, anyway, now what job submission all the problems, depressed ah, if I don't care what lead to set up?

CodePudding user response:

 declare 
Jobno1 int. 
The begin 
Dbms_job. Submit (jobno1 - job number 
'sp_lcn5; ', - execute a stored procedure, '; Don't leave out 
 'Sysdate - the next execution time 
Sysdate + 1 - every time interval, the interval to day 
); 
Commit; 
end; 

This also not line?
Prompt precision overflow, the job is jobno1 and interval involves accuracy, jobno1 is the total will not long

CodePudding user response:

"' - each time interval, the interval in days

CodePudding user response:

Content is not set, it is empty

CodePudding user response:

refer to the eighth floor beyon2008 response:

content is not set, is empty.

To do this is empty is the default

CodePudding user response:

If you do not have permission to create stored procedures or table

CodePudding user response:

Didn't you understand???????

CodePudding user response:

You do not need to initialize jobno1 when submit to submit?