Handling the ORA Error in the Unix Shell Script

advertisements

I am trying to execute a script which actually runs a SQL and returns the value , write to to a CSV file and send it.

/data/oracle/product/10.2.0.4/bin/sqlplus -s user_name/[email protected] @/export/home/script/abc.sql

I want to capture the error whenever there is any error while running the SQL part but it always hangs.

I tried putting "(($?)) && ((ERRORS += 1))" after above statement but it never reaches to that line.

I want to capture the error code in a variable ERROR and exit with the error code.

Kindly help

you can put it under TRY-Catch block. refer this manual

Related Articles

Validating the Date in the Unix Shell Script (ksh)

I am validating the date in Unix shell script as follow: CheckDate="2010-04-09" regex="[1-9][0-9][0-9][0-9]-[0-9][0-9]-[0-3][0-9]" if [[ $CheckDate = *@$regex ]] then echo "ok" else echo "not ok" fi But ksh it is gi

Can the Unix shell script be used to manipulate databases?

I have to read data from some files and insert the data into different tables in a database. Is Unix shell script powerful enough to do the job? Is it easy to do the job in shell script or should I go about doing this in Java?If the data you are tryi

Need help solving a small error in a Unix shell script

I am having a problem with a unix shell script. The script is for renaming the Files and directories which is having spaces with "-" recursively. Example "Stack Overflow" to "Stack-Overflow" This is running perfectly and work

The Unix shell script Email not getting the To: from email

Hi I wrote a shell script. This shell script sends my file.html file out. Everything is great but it seems when I receive the file it does not have a To : address. For example it would look like this instead of this. **Looks like this** Report To : B

In the Unix shell script, what does the $ {0% / *} token mean?

I have the below code snippet in the file (This the first line in the code leaving the comments): scriptdir=${0%/*} I am unable to figure out what is the value that is assigned to the variable 'scriptdir' can anyone please explain what ${0%/*} resolv

Adding the total of a number to 1 in the Unix Shell script

I am trying to take a number as an input and add all the numbers back to 1 so that the script displays the total. E.g. if 5 was the argument it would perform 1 + 2 + 3 + 4 + 5 giving an answer of 15. Any help? Here is my current code: num1=$1 #adder=

As for the Unix shell script

I want to retrieve the file from the INFILE directory which are begining with the file names prefix "BBSCGG_" or "BCT_" or "ACL_" or "ASC" and do the processing inside the for loop INFILE=/ext/test/fil1/ for infile