Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: passing parameters with spaces
Top Forums Shell Programming and Scripting passing parameters with spaces Post 302692993 by sandy162 on Tuesday 28th of August 2012 09:48:08 AM
Old 08-28-2012
Thanks I have added double quotes in parameters in Step 2 and step 3 but still the result is not as expected.
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

4. Wrong Result because "Men Shirt" is in two different lines
Code:
"abc"
"desf"
"dev"
"sdv"
"XYZ"
"Men
Shirt"
"44"
"7542"

 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT MOJAVE

html_cssdefaults

doctools::html::cssdefaults(n)					Documentation tools				    doctools::html::cssdefaults(n)

__________________________________________________________________________________________________________________________________________________

NAME

       doctools::html::cssdefaults - Default CSS style for HTML export plugins

SYNOPSIS

       package require Tcl  8.4

       package require doctools::html::cssdefaults  ?0.1?

       ::doctools::html::cssdefaults::contents

_________________________________________________________________

DESCRIPTION

       This  package provides a single command providing access to the text of the default CSS style to use for HTML markup generated by the vari-
       ous HTML export plugins.

       This is an internal package of doctools, for use by export plugins, i.e. the packages converting doctools  related  documented  into  other
       formats, most notably HTML.

API

       ::doctools::html::cssdefaults::contents
	      This command returns the text of the default CSS style to use for HTML markup generated by the various HTML export plugins.

BUGS, IDEAS, FEEDBACK
       This document, and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the category doctools
       of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may have for
       either package and/or documentation.

KEYWORDS

       CSS, HTML, doctools, export, plugin, style

CATEGORY

       Documentation tools

COPYRIGHT

       Copyright (c) 2009 Andreas Kupries <andreas_kupries@users.sourceforge.net>

doctools2base								0.1					    doctools::html::cssdefaults(n)
All times are GMT -4. The time now is 06:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy