Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing default parameters from Robout job scheduler to oracle procedure

Status
Not open for further replies.

Cretin

Technical User
Jan 2, 2003
194
0
0
US
I am not a developer I am a job scheduler. We are currently migrating jobs from OEM scheduler to Robot. We have some jobs that require parameters. How do I send parameters specifically default parameters. In grid the codee is . /home/user/run_script.ksh jobname database.schema jobname [],[],[R]

The first 2 parameters are default the third is rerun mode. In grid you need [] to send a default parameter. However in Robot that gives me a message you cannot pass null. How would I send a default in Robot. We pass this to a linux script which then executes a PL/SQL? package/procedure. Any help would be appreciated.

Cretin
 

Perhaps if you replace by quotes and remove commas?:
Code:
. /home/user/run_script.ksh jobname database.schema jobname '' '' ''
You could omit trailing null(s).
[ponder]


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top