Passing argument to a pl/sql block Post: 302191384

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with Argument Passing

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

2. Shell Programming and Scripting

passing Argument

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

3. Shell Programming and Scripting

Using GET, passing argument to bash

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

4. Shell Programming and Scripting

Help required in passing multiple arguments from a shell script to a pl/sql block

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

5. Programming

Passing argument to a program!!

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

6. Shell Programming and Scripting

Help with passing argument

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. Shell Programming and Scripting

Argument passing

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.

8. Shell Programming and Scripting

Passing the result of an anonymous pl/sql block to a shell script

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

9. Shell Programming and Scripting

Passing sql file name as an argument

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

10. UNIX for Beginners Questions & Answers

Passing a second argument

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

LEARN ABOUT DEBIAN

cvm-sql

cvm-sql(7)						 Miscellaneous Information Manual						cvm-sql(7)

NAME

       cvm-sql - CVM SQL Framework

QUERY SUBSTITUTION

       $VAR  and  ${VAR} are replaced with the quoted value of the environment variable named VAR.  Use the second form when VAR contains anything
       other than alpha-numeric or underscore (_) characters.  Do not include quotes in the query.  The variables account and domain  contain  the
       account and domain names given by the CVM client.  $$ is replaced with a single dollar sign.

QUERY RESULTS

       The query must produce the following fields exactly in order.  All required fields must not be null or empty.

       1.     Password, encrypted with crypt(3) (required)

       2.     Actual account name (required)

       3.     User ID (integer) (required)

       4.     Group ID (integer) (required)

       5.     Directory (required)

       6.     Real name (optional)

       7.     Login shell (optional)

       8.     Group name (optional)

       9.     Domain name (optional)

       10.    System account name (optional)

       11.    System account directory (optional)

       12.    Mailbox path (optional)

DEFAULT QUERY

       SELECT  password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE
       username=$account AND domain=$domain

SEE ALSO

       cvm-mysql(8), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/cvm/cvm.html

																	cvm-sql(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with Argument Passing

Discussion started by: A_Rod

2. Shell Programming and Scripting

passing Argument

Discussion started by: Shahul

3. Shell Programming and Scripting

Using GET, passing argument to bash

Discussion started by: Rhije

4. Shell Programming and Scripting

Help required in passing multiple arguments from a shell script to a pl/sql block

Discussion started by: ramakanth_burra