Hi,.
I need a help with below strange behaviour.
I use into script parameters as
read A
read B
and my parameter B (password from Active directory) is changed by adding backslash to all characters (123456as; -> \1\2\3\4\5\6\a\s\ and I use it as parameter into script.
When I pass it to Oracle utility FNDCPASS it enclosed into quotation strings and therefore I recieved all with \'s.
Is exist posibility pass parameter without ".
P.S.
Piece of code is ->
Thanks and wait for answers. Staas.
Last edited by joeyg; 06-27-2011 at 11:45 AM..
Reason: Please wrap CodeTags around scripts and data
I run this script in EOF manner ->
I can not use transfer parameter into script due to it cause problem with some spec. characters (like & ' '' . Therefore I transfer them with read command. (as I explained above).
After parameter B is read it go as passnew into FNDCPASS utility and all \'s before characters are entered into DB.
When you run FNDCPASS from command line with \'s all OK.
I found, that passnew enclose with " and this cause problem.
What you can advice with this issue.
Thanks Staas.
Last edited by Franklin52; 06-28-2011 at 03:39 AM..
Reason: Please use code tags for code and data samples, thank you
hi Guys,
is there a way to pass parameter into oracle store procedure by reading date range in file and increment accordingly. Something like this
file.txt
01-JAN-2015
03-JAN-2015
sqlplus -s user/pwd@DB
execute TEST( to_date( '01-JAN-2015, 'dd.mm.yyyy' ), to_date( '03-JAN-2015', ... (1 Reply)
Hi.
How do I achieve this
sh /EDWH-DMT02/script/MISC/exec_sql.sh "@/EDWH-DMT02/script/others/CSM_CKC/Complete_List.sql ${file_name}" Complete_List.txt
The /EDWH-DMT02/script/MISC/exec_sql.sh has two parameters and it's working fine with this
sh /EDWH-DMT02/script/MISC/exec_sql.sh... (7 Replies)
Hi,
I have the following files.
->cat scr.sh
export TMP_DIR=/home/user/folder1
export TMP_DIR_2=/home/user/folder2
while read line
do
cat "$line"
done<file_list.dat
------------------------
-> cat file_list.dat
$TMP_DIR/file1.txt
$TMP_DIR_2/file2.txt
---------------------------
-> cat... (6 Replies)
i am passing input parameter 'one_two' to the script , the script output should display the result as below
one_1two
one_2two
one_3two
if
then
echo " Usage : <$0> <DATABASE> "
exit 0
else
for DB in 1 2 3
do
DBname=`$DATABASE | awk -F "_" '{print $1_${DB}_$2}`
done
fi (5 Replies)
Hi
I am looking for a unix command or a small shell script which can takes one parameter and then searches for the passed in the parameter in any or all files under say /home/dev/
Can anyone please help me on this? (3 Replies)
HI all,
I have a parameter file with entries like
$$Name =Abhinav
$$CUTOFF_DATE = 11/11/2209
I am reading a variable from this file using a awk command like :
var2=`awk -F"" "/CUTOFF_DATE/{f=$1;}{print f;}" InputFIleName`
but facing an error like
awk: cmd. line:1:... (3 Replies)
hi
I have a shell script say primary.sh . There is a file called params
my scenario is
primary.sh should read all the values and echo it
for example
i should pass like
$primary.sh params
output would be
Abc
... (2 Replies)
Hi,
I need to read the parameters from a file and assign them to Global variables. I need to read a specific parameter value every time and pass it to the other script.
Suppose i have a parameter file like PARAM.txt
PAR1= VAL1
PAR2= VAL2
PAR3= VAL3
I want to read PAR2 file and in the... (1 Reply)
I have a script where 3 parametrs are passed to it and it creates the file for each site form a template. If i want to
get the 3rd parameter (which is the site) passed to the script to come from another file how I can change the script tp acheive it?
Here is my script:
what i have in the... (15 Replies)
Say I write something like the following:
var1=1
var2=2
for int in 1 2
do
echo "\$var$int"
done
I want the output to be:
1
2
Instead I get something like:
$var1
$var2 (2 Replies)