how to capture oracle function returning 2 values in unix Post: 302410756

Sponsored Content

Top Forums Shell Programming and Scripting how to capture oracle function returning 2 values in unix Post 302410756 by m1xram on Tuesday 6th of April 2010 07:17:11 PM

04-06-2010

Registered User

As Durden indicates functions typically return a value. Even in languages such as Perl which can return arrays and lists they still return these values as a single entity.

With that said I'd like to ask a question. Do you know if the error value comes back from STDERR because the Oracle command fails?

Rather than waiting for an answer I'll assume the above to be the case where an error message is written to STDERR and the command returns a non-zero value as status. Here's some test code. The first script, 'test9a.sh', calls a second script, 'test9b.sh', which can return an error. The error is returned if you specify 'error' as the first parameter to the first script.

Code:

#!/bin/bash
# script test9a.sh

sfile=$(basename $0)

#echo "$sfile: start"
#echo "$sfile: param: $1"

err=""
rval=$(./test9b.sh $1 2>&1 )
rcode=$?
if [ $rcode -ne 0 ]; then 
    err="$rval"
    rval=""
fi
echo "$sfile: rcode=$rcode, rval=\"$rval\", err=\"$err\""

Code:

#!/bin/bash
#script test9b.sh

sfile=$(basename $0)

#echo "$sfile: start"
#echo "$sfile: param: $1"
if [ "$1" == "error" ]; then
    echo "$sfile: Error message" >&2
    exit 1
fi
echo "$sfile: Return Value $1"
exit 0

Try it out to see if these scripts emulate your situation.

Last edited by m1xram; 04-06-2010 at 08:39 PM.. Reason: Add scripts and answer

m1xram

View Public Profile for m1xram

Find all posts by m1xram

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

2. Programming

string returning function

I have two string returning function in ESQL/C char *segment_name(lbuffer) char *lbuffer; {..... and char *get_bpdvalue(f_name) char *f_name; {...... both declared above main() char *get_bpdvalue(); char *segment_name(); my problem is segment_name works on sprintf and strcpy...

3. Shell Programming and Scripting

Values from Oracle to Unix

Hello Experts how do I get a output value from Oracle to Unix . Please give me sample Unix codings Scenario (Filne name : test.sh <argument > ) --------- 1. Passing argument from unix to sql 2. connecting to Oracle & from oracle get output 3. Pass the output to ...

4. Shell Programming and Scripting

returning from a function

Hi all, I am very new to BASH shell programming. I need to return an integer from a function to the caller function. I did this: but it keeps giving me wrong return: Can someone help me out here, please? Thanks

5. Programming

returning multiple values from a function in C

hi how can I return multiple values from a C function. I tried the following: #include <stdio.h> void foo(int id, char *first_name, char *last_name) { /* this is just an example to illustrate my problem... real code makes use of the "id" parameter. */ first_name = (char...

6. Shell Programming and Scripting

Returning the name of function used

Hi All In my script, I can call on several functions. I have a logging function that is called by any of these functions. What I would like is some way of identifying which function I am using and pass this to the log function as some parameter. Is there some built in command or way of...

7. Shell Programming and Scripting

how to pass the values to unix shell from the oracle stored procedure.

Hi i am calling a stored procedure from unix shell like this call test_proc('0002','20100218'); the stored procedure was giving output like this dbms_output.put_line(' processed earlier'); i want to see the output in the unix shell where i called. Thanks barani

8. Shell Programming and Scripting

unix capture oracle function error

Hi, I want to execute an oracle function from unix script so for that I created a sample oracle function as below: create or replace function test_fn(test_date out varchar2) RETURN varchar2 IS BEGIN select to_char(sysdate,'DD-MON-YY') into test_date from dual; return test_date;...

9. Programming

Function Returning Pointer

Hi guys. how a functions such fdopen, ... can return pointer? are these functions use static memory(variables)?

10. Shell Programming and Scripting

Returning and capturing multiple return values from a function

Hi I am pretty confused in returning and capturing multiple values i have defined a function which should return values "total, difference" i have used as #!/usr/bin/ksh calc() { total=$1+$2 echo "$total" diff=$2-$1 echo "$diff" } I have invoked this function as calc 5 8 Now i...

LEARN ABOUT BSD

ching

CHING(6)							   Games Manual 							  CHING(6)

NAME

       ching - the book of changes and other cookies

SYNOPSIS

       /usr/games/ching [ hexagram ]

DESCRIPTION

       The I Ching or Book of Changes is an ancient Chinese oracle that has been in use for centuries as a source of wisdom and advice.

       The  text  of  the  oracle  (as it is sometimes known) consists of sixty-four hexagrams, each symbolized by a particular arrangement of six
       straight (---) and broken (- -) lines.  These lines have values ranging from six through nine, with the even values indicating  the  broken
       lines.

       Each  hexagram  consists  of  two major sections.  The Judgement relates specifically to the matter at hand (E.g., "It furthers one to have
       somewhere to go.") while the Image describes the general attributes of the hexagram and how they apply to one's own life ("Thus	the  supe-
       rior man makes himself strong and untiring.").

       When  any  of  the lines have the values six or nine, they are moving lines; for each there is an appended judgement which becomes signifi-
       cant.  Furthermore, the moving lines are inherently unstable and change into their opposites; a second hexagram	(and  thus  an	additional
       judgement) is formed.

       Normally,  one  consults  the  oracle  by  fixing  the  desired	question  firmly  in  mind and then casting a set of changes (lines) using
       yarrow-stalks or tossed coins.  The resulting hexagram will be the answer to the question.

       Using an algorithm suggested by S. C. Johnson, the UNIX oracle simply reads a question from the standard input (up to an  EOF)  and  hashes
       the  individual	characters in combination with the time of day, process id and any other magic numbers which happen to be lying around the
       system.	The resulting value is used as the seed of a random number generator which drives a simulated coin-toss divination.  The answer is
       then piped through nroff for formatting and will appear on the standard output.

       For  those  who wish to remain steadfast in the old traditions, the oracle will also accept the results of a personal divination using, for
       example, coins.	To do this, cast the change and then type the resulting line values as an argument.

       The impatient modern may prefer to settle for Chinese cookies; try fortune(6).

SEE ALSO

       It furthers one to see the great man.

DIAGNOSTICS

       The great prince issues commands,
       Founds states, vests families with fiefs.
       Inferior people should not be employed.

BUGS

       Waiting in the mud
       Brings about the arrival of the enemy.

       If one is not extremely careful,
       Somebody may come up from behind and strike him.
       Misfortune.

7th Edition							   May 20, 1985 							  CHING(6)

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

Discussion started by: trichyselva

2. Programming

string returning function

Discussion started by: jisc

3. Shell Programming and Scripting

Values from Oracle to Unix

Discussion started by: Krishnaramjis

4. Shell Programming and Scripting

returning from a function

Discussion started by: alirezan