Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

passing parameters with spaces

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting passing parameters with spaces
# 1  
Old 08-21-2012
passing parameters with spaces
we are using following script to execute stored procedue. The problem is run_pmcmd.ksh script is using $*
parameter which is not taking in account 'Men Shirt' parameter which includes spaces.
1. Step 1
Code:
run_pmcmd.ksh  CONVERT_TEST

script for run_pmcmd.ksh
Code:
/u01/$(whoami)/run_pmcmd.ksh Keae $*

2. Step 2
script for CONVERT_TEST
Code:
#parameters are userid, password, database, db link, owner, div, dept, style
U run_convert.ksh abc desf dev sdv XYZ 'Men Shirt' 44 7542

3. Step 3
script for run_convert.ksh
Code:
USER=$1;       export USER
PASSWD=$2;     export PASSWD
SID=$3;        export SID
DB=$4;         export DB
OWNER=$5;      export OWNER
DIV=$6;        export DIV
DEPT=$7;       export DEPT
STYLE=$8;      export STYLE
 
$ORACLE_HOME/bin/sqlplus ${USER}/${PASSWD}@${SID} >>./CONVERT_TEST${DEPT}.log <<EOC
whenever sqlerror exit 1
execute CNVT_SUMMARY('${DB}', '${OWNER}','${DIV}','${DEPT}','${STYLE}');
EOC

Thanks
Sandy
# 2  
Old 08-21-2012
Use "$@" instead of $* (including the double quotes):
Code:
/u01/$(whoami)/run_pmcmd.ksh Keae "$@"

# 3  
Old 08-27-2012
Sorry but I still got the same error and parameter did not pass through correctly.
# 4  
Old 08-27-2012
Can you please post the whole run_convert.ksh and run_pmcmd.ksh and sample input.
# 5  
Old 08-27-2012
Please find the run_convert.ksh in my first post. Actually problem is when passing parameter to stored procedure when the double quotes or single quotes are getting lost. Question - Please let me know how to pass parameter in "CONVERT_TEST
" script so that "run_convert.ksh" script can have 'Men Shirt' parameter. As of now it passing as 'Mens.
# 6  
Old 08-27-2012
Where are these arguments coming from? How are the arguments supplied into $* / "$@" ? They may be already split by the time you get them, meaning, your script has to guess whether to un-split them or not...

Put this on a line by itself: printf "%s\n" "$@" and tell me what it prints. If 'men shirt' is split across two lines, then your script is already getting the arguments pre-split and the problem is in whatever is calling your script.
# 7  
Old 08-27-2012
you are right, yes parameter is coming in two lines. Please let me know where and how to fix it.
Code:
"Men
Shirt"

I think it is has to do with Informatica - which does not take into consideration - double quote, single quote and script is using pmcmd commnd to run the script.
Last edited by sandy162; 08-27-2012 at 05:48 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Passing parameters with spaces between scripts

I have 2 scripts. test.sh, which calls submit2.sh. One of the parameters contains space and is quoted. ((((./submit2.sh Group_1_2_AMS_DAILY_CORE_GRP03 AMS AMS_D 'DAILY REPORT PROCEDURES'; echo $?>&3) | tee 1.log >&4)3>&1) | (read xs; exit $xs)) 4>&1 echo parm 1 = $1 echo parm 2 = $2... (1 Reply)
Discussion started by: andyclam
1 Replies

2. Shell Programming and Scripting

Help with passing parameters from a file

Hello Everyone, I have developed a shell script which takes schema id and password as parameter to login into database using sqlplus,runs a query and mails the result. My requirement is that, I dont want to pass userid and password as parameters.Instead,I want to pass say Environment... (4 Replies)
Discussion started by: karthik adiga
4 Replies

3. Shell Programming and Scripting

Passing Parameters to Crontab

Hello Experts, I have a requirement to pass some parameters to Linux cron tab. For ex: My default cron entry looks like this as below: ------------------------------- 55 10 * * --... (7 Replies)
Discussion started by: MaheshChaudhari
7 Replies

4. Shell Programming and Scripting

passing parameters to the script

how can i make a script to run only when parameters are given, if parameters are not given it should through an error , saying "please enter a parameter" for ex: i want a find command to run only when the parameters are given (4 Replies)
Discussion started by: knip
4 Replies

5. UNIX for Dummies Questions & Answers

Passing the parameters through a file

Hi All, I have written a shell script and the script is working fine, I am passing my MIT_ID(NUMBER VALUE) to the shell script from the command prompt and my script is executing as expected. Now I have to pass all the MIT_ID's from a .txt file to the shell script,as I am automating this I... (6 Replies)
Discussion started by: gaur.deepti
6 Replies

6. Shell Programming and Scripting

Passing the parameters using a function

Hi All, I am new to shell scripting required some help in passing the parameter value to the shell script. I am writing a shell script, in the script I have created two functions as below. first function get_trend_ids () { Here I am connecting to the database and getting all the... (3 Replies)
Discussion started by: shruthidwh
3 Replies

7. Shell Programming and Scripting

Automate the passing of parameters

I am writing a script that should read the csv file and pass the values in the file as parameters to the script. The csv file looks like this: TEST_1,20110221 TEST_2,20110220 TEST_3,20110218,20110219 Currently this is how i am running the script ./test.sh <param1> <date> Ex: ./test.sh... (6 Replies)
Discussion started by: stunnerz_84
6 Replies

8. Shell Programming and Scripting

passing parameters using awk

Hi, The below script is working fine awk1.sh ======= awk BEGIN { FS="|" } FNR==NR { f1=$2; next } $1 in f1 && $2 =="xx" && $1 == "DAILY_JOB" {print $3} awk -f awk1.sh a.txt b.txt--Its working fine . When passing parameters its not working .Any help it should be appereciated. ... (4 Replies)
Discussion started by: akil
4 Replies

9. Shell Programming and Scripting

passing more than 9 parameters

hi, i am passing around 14 parameters for a script a=$1 b=$2 c=$3 d=$4 e=$5 f=$6 g=$7 h=$8 i=\"${9}\" shift j=\"${1}\" still for j it is displaying the 1st parameter value..how to make it take the 10th parameter (2 Replies)
Discussion started by: dnat
2 Replies

10. Shell Programming and Scripting

problem in passing parameters with spaces

hi im passing 4 parameters to a file....like /userr/script/go.sql $1 $2 $3 $4 and i get them in the other script and make and insert into the tabke insert into xy values('&1','&2','&3','&4'); what is the problem is tht when any one paramter has a space in them like "airtel... (2 Replies)
Discussion started by: njraman
2 Replies
Login or Register to Ask a Question