Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01843: not a valid month when DBMS_SCHEDULER.RUN_JOB

OraclePSPJun 15 2012 — edited Jun 15 2012
Hi all,

i'am working with
Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
PL/SQL Release 10.2.0.3.0 - Production
CORE	10.2.0.3.0	Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio
NLSRTL Version 10.2.0.3.0 - Production
I have already used other jobs without problems so i think permissions and privileges are correct.

Now i create a new job that call a store procedure like that:
DBMS_SCHEDULER.create_job (
			job_name=>'MY_JOB',
			job_type=>'STORED_PROCEDURE',
			job_action=>'MY_PKG.myProcedure',
		        number_of_arguments=>6,
			auto_drop=>FALSE,
		        enabled=>FALSE,
			comments=>'Job bla bla bla'
		);
Then i try to run this way:
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name=>'MY_JOB', argument_position=>1, argument_value=>'varcharvalue');
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name=>'MY_JOB', argument_position=>2, argument_value=>numbervalue);
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name=>'MY_JOB', argument_position=>3, argument_value=>numbervalue);
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name=>'MY_JOB', argument_position=>4, argument_value=>numbervalue);
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name=>'MY_JOB', argument_position=>5, argument_value=>datevalue);
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name=>'MY_JOB', argument_position=>6, argument_value=>'varchar2value');
DBMS_SCHEDULER.ENABLE('MY_JOB');
DBMS_SCHEDULER.RUN_JOB('MY_JOB');
The date i pass is 15-JUN-12 and before the run the error ORA-01843: not a valid month is raised

Thanks to all suggestion or information provided.
Best Regards
Alex
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2012
Added on Jun 15 2012
1 comment
1,083 views