This content has been marked as final. Show 2 replies
Welcome to the forums.1 person found this helpful
Take a look at my demos here:
Also: Please read the FAQ and learn how to post formatted code listings with
tags. It will help you get responses.
Thanks a lot damorgan for your reply :)
I have gone through the link you provided. I couldn't find any limits on step naming though.
Here is the question again with proper with proper formatting.
I am trying to create a chain_job using dbms_scheduler in <Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit>
BEGIN DBMS_SCHEDULER.create_chain (chain_name => 'test_chain', rule_set_name => NULL, evaluation_interval => NULL, comments => 'Test chain.'); END; -- Chain Created Successfully BEGIN DBMS_SCHEDULER.create_program (program_name => 'test_program', program_type => 'PLSQL_BLOCK', program_action => 'BEGIN null; END;', enabled => TRUE, comments => 'Test program.'); END; -- Program Created Successfully <code> BEGIN DBMS_SCHEDULER.define_chain_step ( chain_name => 'test_chain', step_name => 'step_maximum_length_allowed', program_name => 'test_program'); END; Error at line 1 ORA-27465: invalid value STEP_MAXIMUM_LENGTH_ALLOWED for attribute step_name ORA-06512: at "SYS.DBMS_ISCHED", line 3912 ORA-06512: at "SYS.DBMS_ISCHED", line 1452 ORA-06512: at "SYS.DBMS_SCHEDULER", line 1364 ORA-06512: at line 2
The step_name length I used above is 27 characters.
If I use a step_name of length <= 24 characters, the define_chain_step works.
Does this error have to do with the maximum length allowed for step_name. If so, then the error raised should have reflected that.