SQL> VARIABLE jobno number;
SQL>
SQL> begin
2 DBMS_JOB.SUBMIT(:jobno,
3 'pro_his_dict_jcb;',
4 SYSDATE,'sysdate+1');
begin
DBMS_JOB.SUBMIT(:jobno,
'pro_his_dict_jcb;',
SYSDATE,'sysdate+1')
ORA-06550: line 2, column 2:
PLS-00103: Encountered the symbol "" when expecting one of the following: begin case declare exit for function goto if loop mod null
package pragma procedure raise return select separate type
update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
form table call close current define delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
library OPERATOR_ pipe
jobno
---------
SQL> commit;
Commit complete
SQL> end;
end
ORA-00900: invalid SQL statement
SQL>
SQL> begin
2 DBMS_JOB.SUBMIT(:jobno,
3 'pro_his_dict_jcb;',
4 SYSDATE,'sysdate+1');
begin
DBMS_JOB.SUBMIT(:jobno,
'pro_his_dict_jcb;',
SYSDATE,'sysdate+1')
ORA-06550: line 2, column 2:
PLS-00103: Encountered the symbol "" when expecting one of the following: begin case declare exit for function goto if loop mod null
package pragma procedure raise return select separate type
update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
form table call close current define delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
library OPERATOR_ pipe
jobno
---------
SQL> commit;
Commit complete
SQL> end;
end
ORA-00900: invalid SQL statement
解决方案 »
- OracleParameterCollection 只接受非空的 OracleParameter 类型对象,不接受 OracleParameter 对象。
- 2个用户问题
- oracle vdp 如何使用?
- oracle 备份
- 怎么修改自动的临时表空间为限制大小?
- 如何 查看 sid?
- 9i安装后,Enterprise Manager Console 不能启动,请各位给小弟解惑
- oracle备份时出现快照过旧警告,恢复时不能动了,怎么办?求救!
- 我是一个oracle初学者,安装了oracle服务器版后,却看不到数据库中的表,用toad却能看到...
- JAVA BEAN有个属性long类型,oracle表中对应的字段也是long类型,但是HQL查询出来放在list里出错,应该怎么处理这个字段的问题?
- 函数能不能用dbms_output.put_line()输出?
- oracle授权问题?
begin
DBMS_JOB.SUBMIT(:jobno,'pro_his_dict_jcb;',SYSDATE,'sysdate+1');
commit;
end;
/
--你再试试。貌似没有问题,如果有问题的话,那也可能是字符的问题.看看你输入的单引号是中文输入法下输入的,还是英文单引号!
PLS-00905: object TPEMR.PRO_HIS_PATIENT_BASE is invalid
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 3
jobno
---------
还是报这个错
PLS-00905: object TPEMR.PRO_HIS_PATIENT_BASE is invalid
SQL>
SQL>begin
sys.dbms_job.submit(job => :job5,
what => 'pro_his_patient_visit_gxcyrq;',
next_date => to_date('09-08-2010 09:26:32', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+2/1440');
commit;
end;
/
SQL> begin
dbms_job.run(:job5);
end;
/ 谢谢个各位。