Problem running plsql & unix commands in 1 script Post: 302091837

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Problem running plsql & unix commands in 1 script Post 302091837 by tmarikle on Thursday 5th of October 2006 10:46:18 AM

10-05-2006

Registered User

Quote:

Originally Posted by siog

#!/bin/sh
#
sqlplus -s <<EOF username/password @/dir1/unld_date.sql > /dir2/dt_file.dat
exit 0
#
dt=`cat dt_file.dat`
today_dt=`date +%m%d%Y`
if [ "$dt" = "$today_dt" ]
then
#
# run pl/sql procedures 1 and 2
sqlplus -s <<EOF username/username @/dir3/code1.prc > /dir4/code1.log
@/dir3/code2.prc > /dir4/code2.log
exit
EOF
#
tail -10 /dir4/code1.log > log1.txt
tail -10 /dir4/code2.log > log2.txt
#
exit

Looking at the script again, the answer is clear. You are attempting to use a "here" document with the "<<EOF" statement. Your entire script is being pushed into sqlplus and when it reaches the "exit 0" command, it is exiting and the rest of your script isn't processed by sqlplus, which is why you don't see any error in you code1.log file.

You either need to add the "EOF" as stated by other posters or remove the "<<EOF". sqlplus will run the SQL at this point and let your script continue.

This User Gave Thanks to tmarikle For This Post:

tmarikle

View Public Profile for tmarikle

Find all posts by tmarikle

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

calling plsql function in a unix script

Could anyone please help me. I have a function in plsql that returns a number. But i am listing some records through that function using DBMS_OUTPUT.PUT_LINE. I want to catch those records by executing this function through a unix script. The following shows what i did echo "Connected from...

2. Programming

Running UNIX Commands from C

Hi, -How can I get number of files, cpu usage (percentage), memory usage, disk usage, ...etc, using C program ... I can use unix command ( system(command) )but I want the value to be returned back to my C program to use it in my code? How can I do that? Thanks in advance ...

3. UNIX for Advanced & Expert Users

Calling unix script from sql or plsql

Hi Can anyone please let me know how to call unix scripts from sql or plsql ASAP.

4. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

Hi All, I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not...

5. Programming

running PLSQL scripts through shell script

I am running the following ealth checks on my server there are two databases in my server . MODEL1 and MODEL2 i connect with the first database as sqlplus model1/password Then i exceute a query select x from table

6. Shell Programming and Scripting

Running multiple unix commands in a single script

Hi, I would like to write a script with include more than 6 unix commands. my script like below: echo " script started" ls -ld bdf | grep "rama" tail -10 log.txt ... .. ... now, i want to run above unix commands one by one. example: first the ls -ld command will be...

7. Shell Programming and Scripting

Running unix commands in a perl script

Executing two unix commads via perl script one after another e.g: make clean bsub -i -q short make have tried using exec but the second command doesnt executes

8. Shell Programming and Scripting

How to pass value from plsql script to unix bash?

Hi This is my bash script.i am calling validation.sql and passing a value to it using ${flds}. i want the cnt variable in plsql script to be passed to unix. LOADREC=`sqlplus -s $ORACLE_USR <<-EOF spool $ORACLE_LOG_FILE; echo "barani" @validation.sql #calling the plsql script ${flds}...

9. Shell Programming and Scripting

Problem running db2 commands in awk

Hi , I am trying to use the below in awk but failed, any one assist please, awk '{ print $0; if ( $0 ~ /LOADTMP1/ ) { print $4; Table_name=system($( db2 -x "SELECT TRIM(TD.BSCHEMA) || '.' || TRIM(TD.BNAME) AS TABLE_NAME FROM SYSCAT.TABDEP TD WHERE TD.BTYPE='T' AND...

10. Shell Programming and Scripting

Problem running plsql using printf command on bash shell

I am running plsql using printf on a shell, but i am getting some strange error, can someone point what exactly am i missing, $ echo $SHELL /bin/bash $ printf " > SET serveroutput ON trimspool on feed off echo off > declare > p_val number; > d_val varchar2(10); > begin > SELECT...

LEARN ABOUT DEBIAN

latd.conf

LATD.CONF(5)							File Formats Manual						      LATD.CONF(5)

NAME

       latd.conf - LAT configuration file

SYNOPSIS

       /etc/latd.conf

DESCRIPTION

       /etc/latd.conf is a shell script (run by /bin/sh) that is run when latd is started up using the latcp -s command.
       It contains commands used to customise lat for your site and usually consists of a list of latcp commands.
       latd.conf is run with a minimal PATH and a minimal environment. The variable $LATCP points to the latcp binary used to invoke the script.

   EXAMPLE
	  # /etc/latd.conf
	  # This is a sample configuration file for latd
	  # it is run as s shell script from latcp -s with a minimal
	  # environment and PATH. latcp should be invoked using the
	  # environment variable $LATCP.
	  #
	  # You can fiddle with all the latd parameters you like in here,
	  # the first service announcement will not be made until this
	  # script completes.
	  #

	  # Set the multicast timeout to 30 seconds
	  $LATCP -m 30

	  # Add another login service
	  $LATCP -A -a ZAPHOD -r 100

	  # Add a queued reverse LAT service to a printer on a DECserver
	  $LATCP -A -p /dev/lat/printer -Hdecserver -Vdecserver -Q

	  # Only advertise our service in groups 1-10 and 200
	  $LATCP -G 1-10,200

	  exit

   SEE ALSO
       latcp(8), latd(8)

LAT Server							    June 2 2000 						      LATD.CONF(5)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

calling plsql function in a unix script

Discussion started by: cobroraj

2. Programming

Running UNIX Commands from C

Discussion started by: zainab

3. UNIX for Advanced & Expert Users

Calling unix script from sql or plsql

Discussion started by: ksailesh

4. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

Discussion started by: gauravsachan