Database Administration (MOSC)

MOSC Banner

Trouble Creating Oracle Scheduler Job Chain

edited Apr 9, 2010 4:04AM in Database Administration (MOSC) 5 commentsAnswered
 I am trying to create a two-step job chain in an Oracle 10g (10.2.0.4.0) database.  I created two programs, both of type STORED_PROCEDURE, one with 6 arguments and the other with no arguments.  I can create a chain and define chain steps and chain rules successfully.

But when I try to create a job of type CHAIN with the number_of_arguments parameter set to 6, I get the error message: "ORA-27458: A program of type PL_SQL BLOCK cannot have any arguments."  Of course, I don't have a program of type PLSQL_BLOCK defined.

I have searched the knowledge base with no luck.  Can anyone offer a solution to my problem?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center