Sponsored Content
Top Forums UNIX for Advanced & Expert Users How to use parameter in sql script pass from unix script? Post 302509624 by cero on Thursday 31st of March 2011 09:54:46 AM
Old 03-31-2011
Quote:
Originally Posted by apskaushik
Code:
    group="0023"
    sqlplus -s $USER <<EOF 1>>$SBI_LOG/oracle_error.log
        whenever sqlerror exit 1
        set serveroutput off;
        set echo off;
        set termout off;
        set linesize 600;
        set line 1000;
        set pagesize 5000;
        set newpage 0;
        set feedback off;
        set trimspool on;
        set trimout off;
        set define off;
        set verify off;
        set escape off;
        set colsep "|"
        set doc off;
        spool $SBI_LOG/$SPOOLFILE
        @CREATE_SBI_LIST_GROUP.sql $group  
        spool off;
        quit;
EOF

Please advice me what i am missing here.

Thanks
Amit
You turned off variable substitution (in red above).
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to pass values from oracle sql plus to unix shell script

how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies

2. Shell Programming and Scripting

passing parameter from Shell-script to Sql-script

Dear Friends, Please help me to achieve the following: I want to pass one parameter from Shell-script to Sql-script. Example: My ShellScript.sh is calling report.sql like this: /bin/sqlplus /reports.sql And My report.sql is calling many Stored-Procedures like this: exec... (0 Replies)
Discussion started by: subodhbansal
0 Replies

3. Shell Programming and Scripting

Pass parameter from PL/SQL to Unix "as is"

Hi, I need to pass 4 parameters from Oracle Procedure to Unix Shell script.. procedure signature :- UNIX Shell script: Problem: 1. Suppose pdffile and pdfresult has Null values in Oracle procedures but unix shell will read parameters by spaces so I am getting wrong parameters... (7 Replies)
Discussion started by: sandy162
7 Replies

4. UNIX for Advanced & Expert Users

Pass parameter to the main script from wrapper script

Hi, I am writing a wrapper script(wrap_script.sh) to one of the main scripts (main_script.sh) The main script is executed as following: ./main_script.sh <LIST> <STARTDATE> <ENDDATE> looks for a parameter which is a LIST(consists of different list names that need to be processed), START/END... (0 Replies)
Discussion started by: stunnerz_84
0 Replies

5. Shell Programming and Scripting

pass null value to sql script from korn shell script

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)
Discussion started by: megha2525
11 Replies

6. Post Here to Contact Site Administrators and Moderators

Unable to pass shell script parameter value to awk command in side the same script

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)
Discussion started by: Ashunayak
0 Replies

7. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

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

8. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (2 Replies)
Discussion started by: Debalina Roy
2 Replies

9. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (3 Replies)
Discussion started by: Debalina Roy
3 Replies

10. Shell Programming and Scripting

Pass script with parameter in korn shell script

I have written a script which will take input parameter as another script. However, if the script passed as input parameter has parameters then this script doesn't work. I have a script b.ksh which has 1 and 2 as parameters I have a script c.ksh which has 3,4 and 5 as parameters vi a.ksh... (1 Reply)
Discussion started by: Vee
1 Replies
snntpd,v0.3.8(8)					      System Manager's Manual						  snntpd,v0.3.8(8)

NAME
snntpd - small news server SYNOPSIS
snntpd [-t timeout] [-P] [-S] [logger...] DESCRIPTION
snntpd is a small news server. It needs to be run under inetd or tcpserver, as root or as the owner of /var/spool/sn. snntpd does not fork into the background. It expects to read and write from and to the network on descriptors 0 and 1. ARGUMENTS
logger... (usually /usr/bin/logger) is taken to be a logging program, and all log output is piped to it. If logger... is not specified, log messages are directed to descriptor 2. OPTIONS
-t timeout specifies how long snntpd should wait for input before it gives up and exits. timeout is in seconds and defaults to 600. -P snntpd includes it's pid in log output. -S Suppress NNTP greeting on startup. This is useful if you want to perform authentication before running snntpd, or want to provide your own greeting, from a wrapper. POSTING AND POSTING PERMISSIONS
Posts are usually handled externally by the /usr/sbin/SNPOST script, which is responsible for fine-grain posting control; handling of con- trol messages; and the ultimate distribution of the posted article. snntpd permits or denies posting in a very simple manner: If /var/spool/sn/.nopost exists, posting is not allowed. Otherwise, if the environment variable POSTING_OK is not set, posting is not allowed. Otherwise if POSTING_OK is set (to the empty string), posting is generally allowed, and all POSTed articles are piped to the SNPOST script, which has the final say in the matter. The value of $POSTING_OK is not currently used, but is reserved. FILES
/var/spool/sn/.fifo If this file exists, and is a fifo, snntpd will write the name of a newsgroup into it as that newsgroup becomes the current one. If the fifo does not exist snntpd will not create it. /var/spool/sn/.noservice If this file exists, snntpd will display its first line and exit. If the file can't be read or is empty, a default message is dis- played. This is useful for temporarily disabling the news server while you perform any maintenance. /var/spool/sn/.nopost See POSTING PERMISSIONS above. /var/spool/sn/.SNPOST If this script or program exists, it is invoked instead of SNPOST to accept a posted article. /var/spool/sn/news.group.name/.nopost These files really belong to SNPOST, and it is unfortunate that snntpd has to check for their existence to determine the posting flag for the LIST command. See /usr/sbin/SNPOST. /var/spool/sn/news.group.name/.info If this file exists, its first line is taken as the description of that group for use with the LIST NEWSGROUPS command. /var/spool/sn/news.group.name/.times is a binary file containing entry times, to support the NEWNEWS command. /var/spool/sn/news.group.name/.created is an empty file retained for it's timestamp, to support the NEWGROUPS command. SIGNALS
If snntpd catches SIGHUP, the files /var/spool/sn/{.fifo,.noservice,.nopost} (see below) are checked again, as they are during startup. Other signals have default behaviour. ENVIRONMENT VARIABLES
See also /usr/sbin/SNPOST for a list of environment variables exported by snntpd. PATH The PATH must be set such that snntpd can find SNPOST in order to accept postings. If PATH does not include /usr/sbin, /usr/sbin will be appended to it. POSTING_OK This variable helps determine the site-wide posting policy. See POSTING PERMISSIONS above. TCPREMOTEIP If this value is set, it is taken to be the dotted-quad IP address of the connecting client. If it is not set, snntpd attempts to derive it for itself, and then set its value. TCPLOCALIP as above, but for the server's dotted-quad IP. SNROOT If this is set and is not empty, the value is used everywhere in place of /var/spool/sn, the default news spool directory. SEE ALSO
snsend(8), /usr/sbin/SNPOST N.B. Harold Tay snntpd,v0.3.8(8)
All times are GMT -4. The time now is 12:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy