SQL> create table t1 (id number);Table created.SQL> create sequence seq start with 1001 increment by 1;Sequence created.SQL> insert into t1 values(seq.nextval);1 row created.SQL> commit;Commit complete.SQL> variable n number;
SQL> begin
2 dbms_job.submit(:n,'add_t1',sysdate,'sysdate+1/1440/2');
3 commit;
4 end;
5 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 100:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 2
是什么错误 怎么解决啊 本人菜鸟 刚学 ....
SQL> begin
2 dbms_job.submit(:n,'add_t1',sysdate,'sysdate+1/1440/2');
3 commit;
4 end;
5 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 100:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 2
是什么错误 怎么解决啊 本人菜鸟 刚学 ....
解决方案 »
- 90分给1人,其他大家分求,ORACLE同步到MYSQL方案。
- 几个ORACLE问题请帮忙!!!
- 问个基础的安装问题
- ADO中的这个查询语句怎么又错误呢?求解释~~~
- 触发器调用过程报错,求助!
- 远程登录oracle 急急 求助高手
- 如何在同一台机器中测试与oracle的连接???
- 在OCI中怎样将PL/SQL查询结果返回给应用程序,是什么类型的参数?
- Oracle 8i R2 (8.1.6) for NT 企业版在windows 2000 advanced server下的安装?
- 关于oracle删除表空间问题
- 关于ORACLE用户和密码的问题?十分怪讶
- 求救,客户机可以tnsping通但无法连接,服务器上访问数据库正常。
VARIABLE n NUMBER;
dbms_job.submit(:n, 'add_t1', SYSDATE, 'sysdate+1/1440/2');
COMMIT;
END;