|
-
Guys,
This is not wroking, i tried in both the ways. Here i'm pasting the eror messages:
PROD>>VARIABLE jobno NUMBER
PROD>>begin
2 DBMS_JOB.SUBMIT(:jobno,
3 'CALL_WEEKLY;',
4 SYSDATE,'SYSDATE + 7');
5 commit;
6 end;
7 /
PL/SQL procedure successfully completed.
PROD>>begin
2 DBMS_JOB.SUBMIT(:jobno, 'CALL_WEEKLY;',
3 sysdate,
4 'NEXT_DAY(TRUNC(SYSDATE),''SUNDAY"")+3/24');
5 end;
6 /
begin
*
ERROR at line 1:
ORA-23319: parameter value "NEXT_DAY(TRUNC(SYSDATE),'SUNDAY"")+3/24" is not
appropriate
ORA-06512: at "SYS.DBMS_JOB", line 57
ORA-06512: at "SYS.DBMS_JOB", line 132
ORA-06512: at line 2
PROD>>VARIABLE jobno NUMBER
PROD>>begin
2 DBMS_JOB.SUBMIT(:jobno, 'CALL_WEEKLY;',
3 sysdate,
4 'NEXT_DAY(TRUNC(SYSDATE),''SUNDAY"")+3/24');
5 end;
6 /
begin
*
ERROR at line 1:
ORA-23319: parameter value "NEXT_DAY(TRUNC(SYSDATE),'SUNDAY"")+3/24" is not
appropriate
ORA-06512: at "SYS.DBMS_JOB", line 57
ORA-06512: at "SYS.DBMS_JOB", line 132
ORA-06512: at line 2
Please figure out my problem, thanks in advance
PNRDBA
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
|