Our Application calls a Shell --> Shell calls a PL/SQL.
Application passes the parameters to Shell and if some of them are NULL, the order of the parameters is getting screwed up.
Explanation: For example, if we have 5 parameters coming from Apps, if #3 is NULL, Shell only gets 4 parameters instead of 5(1, 2, 3, 4), as a result #3 and #4 are getting the values of #4 and #5, and #5 is completely gone.
I wish to get some hard coded value into #3 like 'Empty'.
Asking user to enter something like 'Empty' OR
automating this action behind screens are NOT options.
Issue needs to be handled in Shell, Any suggestions?
Thx,
Sri
Application passes the parameters to Shell and if some of them are NULL, the order of the parameters is getting screwed up.
Explanation: For example, if we have 5 parameters coming from Apps, if #3 is NULL, Shell only gets 4 parameters instead of 5(1, 2, 3, 4), as a result #3 and #4 are getting the values of #4 and #5, and #5 is completely gone.
I wish to get some hard coded value into #3 like 'Empty'.
Asking user to enter something like 'Empty' OR
automating this action behind screens are NOT options.
Issue needs to be handled in Shell, Any suggestions?
Thx,
Sri