Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Exit when sql script give error
Top Forums UNIX for Advanced & Expert Users Exit when sql script give error Post 302963900 by jim mcnamara on Thursday 7th of January 2016 04:40:47 PM
Old 01-07-2016
With some corrections - mind your spaces around [[ and [ :
try:

Code:
status=0
while [[ $i -le 10 && $status -eq 0 ]] 
do
sqlplus -s user/pass@db <<-EOF
@test.sql id${i}
EOF
status=$?
if [ $status -ne 0 ] ; then
   echo "script failed on $i"
fi
done

test.sql code:
Code:
# test.sql
whenever sqlerror exit failure;
alter table t1 add &1 number;
exit 0

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Error while trying to fire a PL/SQL thro Unix Script

hi , I tried running a PL/SQL script through unix shell script. But am getting the following error. "Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus " Kindly suggest. Regards, Samit (5 Replies)
Discussion started by: dharmesht
5 Replies

2. UNIX for Dummies Questions & Answers

connecting to a database through a script...if not give an error msg

Hello , i have a problem in writing the shell script.. i have a script already written n just need to make a change in which when the script is not able to connect to the database ..it should print an error msg on the screen. I have already seen previous posts on how to connect to the... (3 Replies)
Discussion started by: sommer_queen
3 Replies

3. Shell Programming and Scripting

error connecting sql through a shell script

Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly. It was working properly earlier, no clue why i am getting this. Please find the log below: FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008 Program ended. Wed Apr 30... (1 Reply)
Discussion started by: nehak
1 Replies

4. Shell Programming and Scripting

source a property file in script give error

I have sourced a property file in my script like this to load some variables in the script Then i am able to echo all the property file values inside script but the script is not able to recognize other unix commands #!/bin/bash . build.properties mkdir build i am getting error ... (3 Replies)
Discussion started by: codeman007
3 Replies

5. Shell Programming and Scripting

How to grep sql error in shell script and exit the script?

I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts. Here is my script #!/bin/csh -f source .orapass set user = $USER set pass = $PASS cd /opt/data/scripts echo... (2 Replies)
Discussion started by: allinshell99
2 Replies

6. UNIX for Advanced & Expert Users

How to Make Sql Plus Exit with an Error Code

Dear all, How to make sqlplus command to exit with an apt error code in bash script, It always returns 0 for me. Thanks (9 Replies)
Discussion started by: vetrivendhan
9 Replies

7. Shell Programming and Scripting

How to exit a script with error ?

Hi, I have a script ABC which calls another script XYZ. Function of XYZ is to ftp a file from one server to another. code for ABC: #!/bin/ksh PATH=/usr/bin home/user/xyz "$@" exit $? ~ code for xyz: #!/bin/ksh HOSTNAME=$1 SRCNAME=$2 DSTNAME=$3 (4 Replies)
Discussion started by: Salil Gupta
4 Replies

8. Shell Programming and Scripting

How to catch sql error in script?

Hi Gurus, I have a script which send sql query to oracle db and return value to my script. dummy code like below: sqlplus -s user/${PASSWD}@${ORACLE_SID} @${DIR}/query.sql > outputfile using above code, when query has error, it send error to same out put file and exit code is 0, is... (6 Replies)
Discussion started by: ken6503
6 Replies

9. Shell Programming and Scripting

Getting detailed error from sql script

Hello, I have a main.sql file which runs around 5-6 .sql files and each .sql file is spooling it in separate text file. In my shell script I am appending main.sql to one of my log file but I am not able to get detailed error if anything fails from those 5-6 .sql files. Those errors are... (1 Reply)
Discussion started by: sp92
1 Replies

10. Shell Programming and Scripting

Shell script with sql script error

Hi All when I execute from psql prompt, I get the result, when I try to automate using a shell script, the query is not working # `/usr/bin/psql -U postgres -d coba1 -c "select name from users where "Date" > current_date - 30;"` ERROR: column "Date" does not exist LINE 1: select... (2 Replies)
Discussion started by: srilinux09
2 Replies

LEARN ABOUT DEBIAN

dspam_maintenance

dspam_maintenance(1)						   User Commands					      dspam_maintenance(1)

NAME

       dspam_maintenance - remove old signatures and unimportant tokens from the DSPAM storage backend

SYNOPSIS

       dspam_maintenance [--profile=PROFILE] [--logdays=no_of_days] [--signatures=no_of_days] [--neutral=no_of_days] [--unused=no_of_days]
       [--hapaxes=no_of_days] [--hits1s=no_of_days] [--hits1i=no_of_days] [--without-sql-purge] [--with-sql-automatization] [--with-sql-autoup-
       date] [--purgescriptdir=directory] [--with-all-drivers] [--verbose]

DESCRIPTION

       dspam_maintenance  is  used to remove old signatures/tokens and unimportant tokens from the DSPAM storage backend and purge old log entries
       in user and system logs.

       This script can be called from the command line or run from within cron. Either add a line in your crontab  or  add  this  script  in  your
       cron.{hourly,daily,weekly,monthly}.  Running this script every hour might not be the best idea but it's your decision if you want to do so.

OPTIONS

       --profile=PROFILE

	      Specify a storage profile from dspam.conf. The storage profile selected will be used for all database connectivity.

	      NOTE: See dspam.conf for more information.

       --logdays=no_of_days

	      All log entries older than no_of_days days will be removed.

	      NOTE: Default is 31 days. (for more info: man dspam_logrotate)

       --signatures=no_of_days

	      All signatures older than no_of_daysdays will be removed.

	      NOTE:  Default  value  is  set by the PurgeSignatures option in dspam.conf, if this option is not set, the default value is 14 days.
	      This option is only used for the Hash driver.

       --neutral=no_of_days

	      Deletes all tokens from the target users database whose probability is between 0.35 and 0.65 (fairly neutral, useless data).

	      NOTE: Default value is set by the PurgeNeutral option in dspam.conf, if this option is not set, the default value is 90 days.

       --unused=no_of_days

	      Remove stale tokens which have not been used for a long period of time.

	      NOTE: Default value is set by the PurgeUnused option in dspam.conf, if this option is not set, the default value is 90 days.

       --hapaxes=no_of_days

	      Remove tokens with a total hit count below 5 (which will be assigned a hapaxial value by DSPAM).

	      NOTE: Default value is set by the PurgeHapaxes option in dspam.conf, if this option is not set, the default value is 30 days.

       --hits1s=no_of_days

	      Remove tokens with a single SPAM hit.

	      NOTE: Default value is set by the PurgeHits1S option in dspam.conf, if this option is not set, the default value is 15 days.

       --hits1i=no_of_days

	      Remove tokens with a single INNOCENT hit.

	      NOTE: Default value is set by the PurgeHits1I option in dspam.conf, if this option is not set, the default value is 15 days.

       --without-sql-purge

	      Do not use SQL based purging. Only run dspam_clean.

	      NOTE: Default is off (aka: use SQL based purging).

       --with-sql-optimization

	      Run VACUUM (for PostgreSQL/SQLite) and/or OPTIMIZE (for MySQL).

	      NOTE: Default is off (aka: do not use optimizations).

       --with-sql-autoupdate

	      Run SQL based purging with purge day values passed to dspam_maintenance.

	      NOTE: Default is off (aka: do not attempt to modify SQL instructions).

       --purgescriptdir=directory

	      Space separated list of directories where to search for SQL files used for the SQL based purging.

       --with-all-drivers

	      Process all installed storage drivers (not just the active driver).

	      NOTE: Default is true (aka: process all installed drivers).

       --verbose

	      Verbose output while running maintenance script.

EXIT VALUE

       0      Operation was successful.
       other  Operation resulted in an error. Run the script with --verbose to get more information about error.

COPYRIGHT

       Copyright (C) 2002-2010 DSPAM Project
       All rights reserved.

       For more information, see http://dspam.sourceforge.net.

SEE ALSO

       dspam(1), dspam_admin(1), dspam_clean(1), dspam_crc(1), dspam_dump(1), dspam_logrotate(1), dspam_merge(1), dspam_stats(1), dspam_train(1)

dspam_maintenance						   Apr 26, 2010 					      dspam_maintenance(1)
All times are GMT -4. The time now is 08:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy