Unable to pass value from .Shell script to .SQL file
Hi Rudic,
You mean to use .sh file like this.
Code:
#!/bin/sh
echo "please enter case:"
read v_case_nbr
echo "the case number entered is $v_case_nbr"
sqlplus wmtst/wmtst@wmtest <<EOF
@ test.sql ,v_case_nbr
exit;
EOF
I am getting error on this. see if you can provide me exact code is greatly apprecited
Last edited by Don Cragun; 04-29-2015 at 01:32 PM..
Reason: Add CODE tags.
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
This is my script structure
main script calls configure script which needs to be run as a different user and the configure script calls my application installation script. the application instruction script prompts the user for a directory which I need to pass from my main or configure script.
... (4 Replies)
Discussion started by: cmastays
4 Replies
7. Post Here to Contact Site Administrators and Moderators
Variable I have in my shell script
diff=$1$2.diff
id=$2
new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new
I could see value of $id is not passing to the awk... (0 Replies)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
I am trying to automate a testcase . I am installing some software and it waits for user input after displaying "Do you want to continue ? " I am trying to do this in shell scripting.
#!/bin/bash
#!/usr/bin/expect -f
/usr/bin/expect << EOF
spawn apt-get install openjdk-7-jdk
expect "*Do you... (1 Reply)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
LEARN ABOUT DEBIAN
collectd-email
COLLECTD-EMAIL(5) collectd COLLECTD-EMAIL(5)NAME
collectd-email - Documentation of collectd's "email plugin"
SYNOPSIS
# See collectd.conf(5)
LoadPlugin email
# ...
<Plugin email>
SocketGroup "collectd"
SocketPerms "0770"
MaxConns 5
</Plugin>
DESCRIPTION
The "email plugin" opens an UNIX-socket over which one can submit email statistics, such as the number of "ham", "spam", "virus", etc.
mails received/handled, spam scores and matched spam checks.
This plugin is intended to be used with the Mail::SpamAssassin::Plugin::Collectd SpamAssassin-plugin which is included in contrib/, but is
of course not limited to that use.
OPERATION
This plugin collects data indirectly by providing a UNIX-socket that external programs can connect to. A simple line based protocol is used
to communicate with the plugin:
o E-Mail type (e.g. "ham", "spam", "virus", ...) and size (bytes):
e:<type>:<size>
If "size" is less than or equal to zero, "size" is ignored.
o Spam score:
s:<value>
o Successful spam checks (e.g. "BAYES_99", "SUBJECT_DRUG_GAP_C", ...):
c:<type1>[,<type2>,...]
Each line is limited to 256 characters (including the newline character). Longer lines will be ignored.
SEE ALSO collectd(1), collectd.conf(5)AUTHOR
The "email plugin" has been written by Sebastian Harl <sh at tokkee.org>.
The SpamAssassin-plugin has been written by Alexander Wirt <formorer at formorer.de>.
This manpage has been written by Florian Forster <octo at verplant.org>.
5.1.0 2012-04-02 COLLECTD-EMAIL(5)