Unix Oracle Post: 302069766

Sponsored Content

Top Forums Shell Programming and Scripting Unix Oracle Post 302069766 by dhananjaysk on Wednesday 29th of March 2006 05:34:39 AM

03-29-2006

Registered User

One more problem

Quote:

Originally Posted by tmarikle

Code:

line_no=10
pro=TEST
set -f # <-- Turn globbing off (no filenames)
{
echo "WHENEVER SQLERROR EXIT 1
set feedback off verify off pagesize 0
select x from tp_mquote where ct1=0; " | sqlplus -s /
} | while IFS=$(echo '\012\001') read LINE;
do 
    case ${LINE} in
        ORA-*|SP2-*)
             echo "Hido some stuff based on Oracle error"
             echo ${LINE} >> a.out # <-- Echo error message to a.log
        ;;
        *) echo ${LINE} ;;
    esac
done
echo $?
if [ $? -ne 0 ]; then
    global_proc $line_no $proc_name
else
    echo Success
fi
set +f # <-- Turn globbing back on

Many Many thanks for the help and it has worked...

I have one more problem....

Suppose my sql stmt is as follows:-

SELECT a, b, c, d, e, ,f ,g ,h FROM table;
Now I am sending the above select stmt. to a Error Handling shell script.

As Error Handling script will treat this sql statement as positional parameters ..
from $1 - $9. So this will cause problem in executing the above SQL stmt.

So what is the way to deal with it ....

If i use $* in that case it is working...
but along with sql stmt I also want to send the proc_name,Lineno variable then how should i deal with it ..

Thanks
Dhananjay

dhananjaysk

View Public Profile for dhananjaysk

Find all posts by dhananjaysk

9 More Discussions You Might Find Interesting

1. Programming

Oracle 9i on Unix

i am upgrading my Oracle 8i database to 9i that runs on Unix platform. Does this require me to make any changes in Unix so as to run the upgrade successfully? Regards, Gerald.

2. UNIX for Advanced & Expert Users

Oracle and Unix

Hi I am having trouble with a script to export individual schemas to tape from an oracle database. Basicaly I need to export each shema through a pipe with compression and store each shema name in a file with the relevant tape marker.

3. UNIX for Dummies Questions & Answers

Oracle to MySQL through Unix

Hello All, I'm a complete Unix newbie, and I have been asked to provide a solution for the following opportunity: Currently there is an Oracle database residing on a Unix box that I need to connect to on a regular basis from another Unix box. Upon connecting I need to hit multiple tables and...

4. HP-UX

Restore of oracle 8i from hp unix 11.0 to HP unix 11i

Hi, We are planning to migrate oracle 8.1.7.2 (8i) currently installed on a host with HP unix 11.0 to a host with HP Unix 11i. The method we are adopting is backup and restore of all file systems. Could this be a problem, apart from linking libraries on the target system. Thanks for the...

5. Shell Programming and Scripting

Unix + Oracle

Hello people, at the moment, I have a database server running HP-UX and Oracle. From time to time, I need to extract data from oracle, and then do some data management (Awk, sed) within unix. At the moment, what I do is to copy the output from my oracle query and then paste into a file on another...

6. UNIX for Dummies Questions & Answers

unix for oracle

Hi unixers, :) Anyone have any links or online tutorials for Shell Scripting with respect to Oracle . Any example of script calling any Oracle procedure or function or passing parameters is highly appreciated.

7. UNIX for Advanced & Expert Users

oracle to unix

how can i safely transfer a oracle database to a unix system thanks

8. Shell Programming and Scripting

unix-oracle

Hallo Friends, My script looks like this: #!/bin/ksh set -x ######################################################################### # # Name: # statistics.ksh # # Details: # Performs a series of queries on the database to analyse application performance; # reports on backlog of...

9. Programming

Oracle/UNIX

How do you combine the two language.

LEARN ABOUT MOJAVE

set_color

set_color(1)							       fish							      set_color(1)

NAME

       set_color - set_color - set the terminal color

set_color - set the terminal color
   Synopsis
       set_color [-v --version] [-h --help] [-b --background COLOR] [COLOR]

   Description
       Change the foreground and/or background color of the terminal. COLOR is one of black, red, green, brown, yellow, blue, magenta, purple,
       cyan, white and normal.

       o -b, --background Set the background color

       o -c, --print-colors Prints a list of all valid color names

       o -h, --help Display help message and exit

       o -o, --bold Set bold or extra bright mode

       o -u, --underline Set underlined mode

       o -v, --version Display version and exit

       Calling set_color normal will set the terminal color to whatever is the default color of the terminal.

       Some terminals use the --bold escape sequence to switch to a brighter color set. On such terminals, set_color white will result in a grey
       font color, while set_color --bold white will result in a white font color.

       Not all terminal emulators support all these features. This is not a bug in set_color but a missing feature in the terminal emulator.

       set_color uses the terminfo database to look up how to change terminal colors on whatever terminal is in use. Some systems have old and
       incomplete terminfo databases, and may lack color information for terminals that support it. Download and install the latest version of
       ncurses and recompile fish against it in order to fix this issue.

Version 1.23.1							  Sun Jan 8 2012						      set_color(1)