问一下这样的存储过程为啥建立job会出现这样的失败?
---1.创建一个自定义过程
reate or replace procedure resch as
begin
delete from res_ge1 where a = 2;
commit;
delete from res_ge2 where b = 3;
commit;
delete from res_ge3 where c = d;
commit;
end;
/
---------上面的存储过程,建立job后报错:
ORA-06550: 第 11 行, 第 0 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
begin case declare
end exception exit for goto if loop mod null pragma raise
return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
job3
reate or replace procedure resch as
begin
delete from res_ge1 where a = 2;
commit;
delete from res_ge2 where b = 3;
commit;
delete from res_ge3 where c = d;
commit;
end;
/
---------上面的存储过程,建立job后报错:
ORA-06550: 第 11 行, 第 0 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
begin case declare
end exception exit for goto if loop mod null pragma raise
return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
job3
...全文
相关推荐
kettle - JOB循环 , 用于kettle失败后重试 !
kettle - JOB循环 , 用于kettle失败后重试 ! 具体内容请下载查看!这里不多做解析 ! kettle - JOB循环 , 用于kettle失败后重试 ! 具体内容请下载查看!这里不多做解析 !
Oracle存储过程调测及job使用指导
Oracle数据库、存储过程、调测、job作业、日常维护
SQLServer Job运行成功或失败时发送电子邮件通知的图文教程
SQL Server 2005的设置如下: 1.运行SQL Server Surface Area Configuration->Surface Area Configuration for features->选择Database Mail->选择Enable Database mail stored procedures 2.打开SQL Management Studio->Management->Database mail->Configure SMTP Settings. 3.打开SQL Server Agent->Operators->建立一个新的Operator 4.建立一个新Jo
oracle的job定时
oracle的job定时,henyouyongde ziliao
oracle job使用详解
oracle job 使用详解: 每天1点执行的oracle JOB样例


基础和管理
