|
-
Thanks.
But I still cannot work through it by changing the name, any clues?
SQL> variable v_jobnum number
SQL> begin
2 DBMS_JOB.SUBMIT(:v_jobnum,'test',sysdate, 'sysdate +1');
3 end;
4 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 98:
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 131
ORA-06512: at line 2
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|