| how to escape $ in the package name called from shell script [message #461987] |
Tue, 22 June 2010 05:31  |
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
|
Senior Member |
|
|
Hi,
Please refer snippet of my code
val=`sqlplus -s $db_user/$db_passwd<<EOF
set feedback off heading off
var x varchar2(100)
var y varchar2(100)
var z varchar2(100)
exec myco$extract0600.file_batch_proc"('$v',:x,:y,:z);
Here I am unable to escape the $ in the package name 'myco$extract0600'
I tried escaping it by '\' "" but no luck
following is what i tried so far
myco\$extract0600.file_batch_proc"('$v',:x,:y,:z);
"myco$extract0600.file_batch_proc"('$v',:x,:y,:z);
Could you please suggest any option
Thanks and Regards,
Chetana
|
|
|
|
|
|
|
|
| Re: how to escape $ in the package name called from shell script [message #462002 is a reply to message #461987] |
Tue, 22 June 2010 06:05  |
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
|
Senior Member |
|
|
Many Thanks Michel for your quick reply
The " left out while I was trying to anonymise the content
In fact I was trying
[code
"myco$extract0600.file_batch_proc('$v', ,:y,:z)";
myco\$extract0600.file_batch_proc('$v',,:y,:z);
][/code]
But it did not work
Just now I tried(arbitrarily) following and it worked (2 \\)
myco\\$extract0600.file_batch_proc('$v',:x,:y,:z);
Many Thanks for your quick reply
Thnaks and Regards,
Chetana
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
