-
Dbms_jobs.submit
I submitted this job with the following error on 8.1.6 on Unix.
variable jobno number;
begin
dbms_job.submit(:jobno,'trunc_table','NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 6/24');
COMMIT;
END;
/
I got the following error.
ERROR at line 2:
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at line 2
How can I resolve this? Thanks
-
Try this...
variable jobno number;
begin
dbms_job.submit(:jobno,'trunc_table;','NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 6/24');
COMMIT;
END;
/
Cheers!
OraKid.
-
I used the corrected code the error came back and wonder what is wrong with the jobno
-
NEXT_DATE must be supplied as a date date, not a string.
Also, it's better practice to name the parameters as you pass them ...
Code:
variable jobno number;
begin
dbms_job.submit
(
jobno => :jobno,
what => 'trunc_table',
next_date => NEXT_DAY(TRUNC(SYSDATE), 'MONDAY') + 6/24
);
commit;
END;
/
-
Any explantion for this error
ORA-06550: line 2, column 4:
PLS-00306: wrong number or types of arguments in call to 'SUBMIT'. Thanks.
-
Parameter TWO which is ur procedure name shld hv a semi-colon. That might be an error...
dbms_job.submit(:jobno,'trunc_table;','NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 6/24')
Cheers!
OraKid.
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
|