| How can I add the 10 th parameter to the shell script [message #171155] |
Mon, 08 May 2006 13:57  |
a04417
Messages: 3
Registered: May 2006
Location: King of Prussia, PA
|
Junior Member |
|
|
What if the shell script takes more than 9 parameters?? How do I access the 10th parameters thru shell script???
I need to call a PL/SQL procedure
PFPC_INVOICES_PROC (v_check_date in VARCHAR2, v_set_of_books_id in NUMBER)
that has two IN parameters from the shell script?
example of my code using one parameter:
>
> v_date="" # Input Parameter
>
> ##echo "Show" $#
> v_param_cnt=0
> v_date='2001-01-01'
> for var in $*
> do
> v_param_cnt=$v_param_cnt+1
> ## echo "$v_param_cnt Input Parameter= $var"
> if ((v_param_cnt=9))
> then
> v_date=$var
> else
> echo "Some Other Parameter= $var"
> fi
> done
> ###########################
> # Display Current Status #
> ###########################
> v_date="'$v_date'"
> ##echo "Converted Date= $v_date"
> #################################
> # start main package procedure: #
> #################################
> LOGIN=`cat /u01/ora11/.apps_login`
> sqlplus
$LOGIN
set serveroutput on size 1000000;
set feedback off;
exec DBMS_OUTPUT.put_line('Procedure PFPC_INVOICES_PROC In Execution Mode...');
BEGIN
PFPC_INVOICES_PROC($v_date);
DBMS_OUTPUT.put_line('Procedure PFPC_INVOICES_PROC is done...');
EXCEPTION
|
|
|
|
|
|
| Re: How can I add the 10 th parameter to the shell script [message #171417 is a reply to message #171157] |
Tue, 09 May 2006 19:53  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
you should be able to make it look like fewer parameters by bundling some together with quotes. This isn't working code, but you'll get the idea...
t.ksh 123 abc def ghij 777
----- --- --- --- ---- ---
$0 $1 $2 $3 $4 $5
t.ksh 123 "abc def ghij" 777
----- --- ------------ ---
$0 $1 $2 $3
echo $2 | read X Y Z
then $X contains abc
So $2 becomes "abc def ghij" and then you can split it up further inside your script.
|
|
|
|
|
|
| Re: How can I add the 10 th parameter to the shell script [message #171608 is a reply to message #171417] |
Wed, 10 May 2006 09:37 |
a04417
Messages: 3
Registered: May 2006
Location: King of Prussia, PA
|
Junior Member |
|
|
Thank you for you reply, but I sent the wrong shell script.
The problem is: I have PL/SQL procedure with IN parameters date and number. Users will enter first date and then number. Date is parameter 9, number is parameter 10
CREATE OR REPLACE PROCEDURE PFPC_INACTIVE_SUPPLIERS_TEST (v_check_date in VARCHAR2, v_set_of_books_id in NUMBER)
IS
Then, in the shell script I need to call procedure with parameters.
#!/bin/ksh
# This script is to run a data extract
# from oracle and to push the data to the
# mainframe.
##. /u01/ora11/appdappl/APPSORA.env
## v_temp_ret_code=0 # SHELL Temporary Return Status code
##echo $v_temp_ret_code
## v_ret_code=0 # SHELL Return Status code
##echo $v_ret_code
v_check_date="" # Input Parameter
v_set_of_books_id=0
##`v_check_date '+%d%b%Y'`
echo "Show" $#
v_param_cnt=0
for var in $*
do
v_param_cnt=$v_param_cnt+1
echo "$v_param_cnt Input Parameter= $var"
if ((v_param_cnt=9))
then
v_check_date=$var
else
echo "Some Other Parameter= $var"
fi
done
for num in $*
do
v_param_cnt=$v_param_cnt+1
if
((v_param_cnt=10))
then
v_set_of_books_id=$num
else
echo "Some Other Parameter= $num"
fi
done
# Display Current Status #
###########################
v_check_date="'$v_check_date'"
echo "Converted Date= $v_check_date"
v_set_of_books_id=$v_set_of_books_id
echo "Set Of Books ID = $v_set_of_books_id"
#################################
# start main package procedure: #
#################################
LOGIN=`cat /u01/ora11/.apps_login`
sqlplus << EOJ
$LOGIN
set serveroutput on size 1000000;
set feedback off;
exec DBMS_OUTPUT.put_line('Procedure PFPC_INACTIVE_SUPPLIERS_TEST In Execution Mode...');
BEGIN
PFPC_INACTIVE_SUPPLIERS_TEST($v_check_date, $v_set_of_books_id);
DBMS_OUTPUT.put_line('Procedure PFPC_INACTIVE_SUPPLIERS_TEST is done...');
EXCEPTION
|
|
|
|
| Re: How can I add the 10 th parameter to the shell script [message #171610 is a reply to message #171157] |
Wed, 10 May 2006 09:45 |
a04417
Messages: 3
Registered: May 2006
Location: King of Prussia, PA
|
Junior Member |
|
|
Thank you for you reply, but I sent the wrong shell script.
The problem is: I have PL/SQL procedure with IN parameters date and number. Users will enter first date and then number. Date is parameter 9, number is parameter 10
CREATE OR REPLACE PROCEDURE PFPC_INACTIVE_SUPPLIERS_TEST (v_check_date in VARCHAR2, v_set_of_books_id in NUMBER)
IS
Then, in the shell script I need to call procedure with parameters.
#!/bin/ksh
# This script is to run a data extract
# from oracle and to push the data to the
# mainframe.
##. /u01/ora11/appdappl/APPSORA.env
## v_temp_ret_code=0 # SHELL Temporary Return Status code
##echo $v_temp_ret_code
## v_ret_code=0 # SHELL Return Status code
##echo $v_ret_code
v_check_date="" # Input Parameter
v_set_of_books_id=0
##`v_check_date '+%d%b%Y'`
echo "Show" $#
v_param_cnt=0
for var in $*
do
v_param_cnt=$v_param_cnt+1
echo "$v_param_cnt Input Parameter= $var"
if ((v_param_cnt=9))
then
v_check_date=$var
else
echo "Some Other Parameter= $var"
fi
done
for num in $*
do
v_param_cnt=$v_param_cnt+1
if
((v_param_cnt=10))
then
v_set_of_books_id=$num
else
echo "Some Other Parameter= $num"
fi
done
# Display Current Status #
###########################
v_check_date="'$v_check_date'"
echo "Converted Date= $v_check_date"
v_set_of_books_id=$v_set_of_books_id
echo "Set Of Books ID = $v_set_of_books_id"
#################################
# start main package procedure: #
#################################
LOGIN=`cat /u01/ora11/.apps_login`
sqlplus << EOJ
$LOGIN
set serveroutput on size 1000000;
set feedback off;
exec DBMS_OUTPUT.put_line('Procedure PFPC_INACTIVE_SUPPLIERS_TEST In Execution Mode...');
BEGIN
PFPC_INACTIVE_SUPPLIERS_TEST($v_check_date, $v_set_of_books_id);
DBMS_OUTPUT.put_line('Procedure PFPC_INACTIVE_SUPPLIERS_TEST is done...');
EXCEPTION
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
