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-27372: length of action and arguments exceeds platform limit 1024

JellyOct 24 2017 — edited Oct 24 2017

ORA-27372: length of action and arguments exceeds platform limit 1024

ORA-06512: at "SYS.DBMS_ISCHED", line 185

ORA-06512: at "SYS.DBMS_SCHEDULER", line 486

ORA-06512: at line 3

27372. 00000 -  "length of action and arguments exceeds platform limit %s"

*Cause:    The total length of the job or program action and the arguments

           exceeds the platform limit specified.

*Action:   Reduce the total length by specifying fewer and/or shorter

           arguments

test.bat

echo %1 > C:\test.txt

BEGIN

Dbms_Scheduler.Create_Job(

job_name => 'TEST',

job_type => 'EXECUTABLE',

job_action => 'C:\TEST.bat',

job_class => 'DEFAULT_JOB_CLASS',

Auto_Drop => FALSE,

number_of_arguments => 1,

enabled => false);

Dbms_Scheduler.Set_Job_Argument_Value( Job_Name => 'TEST', Argument_Position => 1, Argument_Value =>CONVERT( '好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好好', 'ZHT16MSWIN950', 'UTF8' ));

END;

begin

Dbms_Scheduler.RUN_JOB('TEST');

END;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2017
Added on Oct 24 2017
2 comments
573 views