05-02-2008
Passing argument to a pl/sql block
Hi,
How can I pass an argument to a pl/sql block through perl/unix shell scripting.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings,
I am wrapping the monitoring commands like vmstat, sar, iostat and call via arguments
I want ./unix_stats.sh -v vmstat -p <SEC> -d <Duration>
to give vmstat values, and similarly iostat etc.,.
Also if I give ./unix_stats.sh -v vmstat -i iostat -p <SEC> -d <Duration> should give... (4 Replies)
Discussion started by: A_Rod
4 Replies
2. Shell Programming and Scripting
Hi All,
i have script like below..
echo "1) first option"
echo ""
echo "2) second option"
echo ""
echo "*) please enter the correct option"
read select
case $select in
1) echo "first option selected"
;;
2) echo "second option selected"
;;
*) echo "please enter the correct... (4 Replies)
Discussion started by: Shahul
4 Replies
3. Shell Programming and Scripting
Hi guys!
So, I use GET ( Simple user agent using LWP library. ) on a remote text file that is then passed to bash and executed. However, I need to pass that bash script a single argument, and so far nothing that I have tried has worked, although I have learned quite a bit about input/output... (5 Replies)
Discussion started by: Rhije
5 Replies
4. Shell Programming and Scripting
Hi, hope everyone are fine. Please find my issue below, and I request your help in the same
In a configuration file, i have a variable defined as below
TEST = 'One','Two','Three'
I am trying to pass this variable in to a sql script which is define in a pl/sql block
as follows,
In the... (1 Reply)
Discussion started by: ramakanth_burra
1 Replies
5. Programming
Hi friends,
I have a small query, hope u will help me with it.
I want to write a small program which would take an integer as an argument, then I want to save that argument in a variable of type int. Could you please help me with it. Here is my program
#include <stdio.h>
int main(int... (4 Replies)
Discussion started by: gabam
4 Replies
6. Shell Programming and Scripting
Hi,
I have a script that is scheduled with cron and runs every night. The cron part looks like this:
00 20 * * 0,1,2,3,4,5,6 /usr/local/bin/BACKUP TBTARM HOT DELETE
My issue is with the 3rd parameter. Somewhere in the script, i want to tell the script to delete some files if the 3rd... (7 Replies)
Discussion started by: dollypee
7 Replies
7. Shell Programming and Scripting
How to pass the alphabet character as a argument in case and in if block?
ex:
c=$1
if a-z ]]
then
echo "alphabet"
case $1 in
a-z) echo "the value is a alphabet"
edit by bakunin: please use CODE-tags. We REALLY mean it. (9 Replies)
Discussion started by: Roozo
9 Replies
8. Shell Programming and Scripting
Hello,
Here is the code i have written to get the count of a plsql query back to the unix.
function checkforCOIDs
{
countcheck=`sqlplus -s $1/$2@$3
whenever oserror exit sql.oscode rollback
whenever sqlerror exit sql.sqlcode rollback
set serverout on size 2000;
set head off feedback off... (2 Replies)
Discussion started by: santosh2eee
2 Replies
9. Shell Programming and Scripting
Hi all,
I have a a file which contains an oracle query. If this file is pushed into a shell script such as the below, it of course works fine.
#!/usr/bin/sh
su - oracle -c 'sqlplus -s / as sysdba <<EOF
@/home/cron/ORA/sql/T-ORA006-OracleSessions.sql
exit;
EOF
.
What i am after... (2 Replies)
Discussion started by: nms
2 Replies
10. UNIX for Beginners Questions & Answers
I am trying to pass a second argument like so:
if ] then
export ARG2=$2
else
message "Second argument not specified: USAGE - $PROGRAM_NAME ARG1 ARG2"
checkerror -e 2 -m "Please specify if it is a history or weekly (H or W) extract in the 2nd argument"
fi
however, it always goes... (4 Replies)
Discussion started by: MIA651
4 Replies
LEARN ABOUT DEBIAN
oarnodesetting
oarnodesetting(1) OAR commands oarnodesetting(1)
NAME
oarnodesetting - Change the state and properties of a node in OAR.
SYNOPSIS
oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]]
DESCRIPTION
This command is used to Change the state and properties of a node in OAR.
OPTIONS
-a, --add
Add a new resource.
-s, --state STATE
Set the new state of the node. The available states are: Alive, Absent and Dead.
-m, --maintenance on/off
Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0).
-h, --hostname HOSTNAME
Set the node hostname.
-r, --resource
Set the resource.
--sql
Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'").
-p, --property "PROPERTY=VALUE"
Set the property of the node to the given value.
-n, --nowait
Do not wait for job ends when the node switches to Absent or Dead.
EXAMPLES
oarnodesetting -s Alive -h node012
oarnodesetting -s Absent -h node012
COPYRIGHTS
Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarnodesetting 2012-05-23 oarnodesetting(1)