call function


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting call function
# 1  
Old 03-19-2007
call function

I have a function check_ok in my abc.sh. which return me 1 or 0 . I want to call this fuction through other shell script. this shell also send two parameter to calling function.
Can you please tell me how. I am very new in unix.



#!/bin/bash

date_equal()
{

sqlplus -silent rep/qpalwo@cbi <<END
set pagesize 0 feedback off verify off heading off echo off serverout on size 100000
DECLARE
date1 DATE:=NULL;
date2 DATE:=NULL;
BEGIN
DBMS_OUTPUT.enable(100000);
select hdsg.HLD_DI_SRC_GRP_DATE into date_1 from di_hold.HOLD_DI_SRC_GRP hdsg where hdsg.HLD_DI_SRC_GRP_NAME = $1;

select hdsg.HLD_DI_SRC_GRP_DATE into date_2 from di_hold.HOLD_DI_SRC_GRP hdsg where hdsg.HLD_DI_SRC_GRP_NAME = $2;

select trunc(sysdate) into current_date from dual;
IF current_date = date_1 and current_date = date_2
THEN
DBMS_OUTPUT.put_line('1');
ELSE
DBMS_OUTPUT.put_line('0');
END IF;
END;
/
exit;
END
# 2  
Old 03-19-2007
Quote:
Originally Posted by Jamil Qadir
I have a function check_ok in my abc.sh. which return me 1 or 0 . I want to call this fuction through other shell script. this shell also send two parameter to calling function.
Can you please tell me how. I am very new in unix.



#!/bin/bash

date_equal()
{

sqlplus -silent rep/qpalwo@cbi <<END
set pagesize 0 feedback off verify off heading off echo off serverout on size 100000
DECLARE
date1 DATE:=NULL;
date2 DATE:=NULL;
BEGIN
DBMS_OUTPUT.enable(100000);
select hdsg.HLD_DI_SRC_GRP_DATE into date_1 from di_hold.HOLD_DI_SRC_GRP hdsg where hdsg.HLD_DI_SRC_GRP_NAME = $1;

select hdsg.HLD_DI_SRC_GRP_DATE into date_2 from di_hold.HOLD_DI_SRC_GRP hdsg where hdsg.HLD_DI_SRC_GRP_NAME = $2;

select trunc(sysdate) into current_date from dual;
IF current_date = date_1 and current_date = date_2
THEN
DBMS_OUTPUT.put_line('1');
ELSE
DBMS_OUTPUT.put_line('0');
END IF;
END;
/
exit;
END
Replied in your other posting:

You can invoke the "abc.sh" from your other shell script like:
abc.sh arg1 arg2

In you abc.sh, make your function use these arguments as $1,$2 ... and return 1 or 0.
# 3  
Old 03-19-2007
Quote:
Originally Posted by Jamil Qadir
#!/bin/bash

date_equal()
{

sqlplus -silent rep/qpalwo@cbi <<END
set pagesize 0 feedback off verify off heading off echo off serverout on size 100000
DECLARE
date1 DATE:=NULL;
date2 DATE:=NULL;
BEGIN
DBMS_OUTPUT.enable(100000);
select hdsg.HLD_DI_SRC_GRP_DATE into date_1 from di_hold.HOLD_DI_SRC_GRP hdsg where hdsg.HLD_DI_SRC_GRP_NAME = $1;

select hdsg.HLD_DI_SRC_GRP_DATE into date_2 from di_hold.HOLD_DI_SRC_GRP hdsg where hdsg.HLD_DI_SRC_GRP_NAME = $2;

select trunc(sysdate) into current_date from dual;
IF current_date = date_1 and current_date = date_2
THEN
DBMS_OUTPUT.put_line('1');
ELSE
DBMS_OUTPUT.put_line('0');
END IF;
END;
/
exit;
END

OK - Here's some problems for you to overcome.

Your Oracle looks like it is using character strings for your variables. Which means that must be surrounded by quotes.

If you use quotes in your variables when you call, UNIX will strip them out.

This will get you into some interesting OS/bash dependencies I cannot help you with, but you need to consider.

try abc.sh "\'arg1\'" "\'arg2\'" to pass the single quotes to the arguments as Oracle is expecting.
# 4  
Old 03-19-2007
I exacttly have no idea how I will get the return value in variable. Second recommand me the good site where I can get the answar for such a selly question.
Please also check my function is it ok for retun value.

thanks a lot.

jamil
# 5  
Old 03-20-2007
here is the script which calling my function which i send before.
please check it


thanks a lot

jamil

#!/bin/bash
a =1;
while [ true ]
do
aa = check_statu.sh 'OM' 'BP' ;
if [[ $aa -eq 1 ]] ; then
nohup YEAR_RUN_backup.sh &
nohup YEAR_RUN_backup01.sh &
exit 0
echo "# do something"
exit
fi
echo "# do something else"
sleep 10
done
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Call a Function

Hi I have created a function in a Shell Script test.sh function fnTest() { echo "My first Method } I have called this function in my test.sh cat abc.txt | grep "test" echo " test" fnTest But while running the shell script i got the following error: ... (2 Replies)
Discussion started by: nanthagopal
2 Replies

2. Shell Programming and Scripting

After exit from function it should not call other function

Below is my script that is function properly per my conditions but I am facing one problem here that is when one function fails then Iy should not check other functions but it calls the other function too So anyone can help me how could i achieve this? iNOUT i AM GIVING TO THE... (1 Reply)
Discussion started by: rohit22hamirpur
1 Replies

3. Shell Programming and Scripting

Function call

Hi foiks i am unable to find what is wrong in my code mu functionality is to exit from shell when i give 99 but it is not calling function ext Could you please correct me. read option if ; then ext else echo "out" fi function ext { echo "tested 99 and exit... (12 Replies)
Discussion started by: kojo
12 Replies

4. Infrastructure Monitoring

diffrence between method call and function call in perl

Hello, I have a problem with package and name space. require "/Mehran/DSGateEngineLib/general.pl"; use strict; sub System_Status_Main_Service_Status_Intrusion_Prevention { my %idpstatus; my @result; &General_ReadHash("/var/dsg/idp/settings",\%idpstatus); #print... (4 Replies)
Discussion started by: Zaxon
4 Replies

5. Shell Programming and Scripting

Function Call

Hi, I have a string corresponding to a function. How I can call that function without if statement? Thanks in advance. (4 Replies)
Discussion started by: Zaxon
4 Replies

6. Shell Programming and Scripting

Function Call

How we can start a process if doesn't exists before? (1 Reply)
Discussion started by: Zaxon
1 Replies

7. Shell Programming and Scripting

help on function call

hello, when i call function inside awk traitement it doesn't work, i don't have error execution but i don't get result and if i call the function outside awk traitement it work well.. there's something special in awk call function?? here is the example : awk -F "," '{ {first=$1; sec=$2;... (3 Replies)
Discussion started by: kamel.seg
3 Replies

8. Shell Programming and Scripting

function call

hi, can any one help me to correct this function call. awk -F "," '{ {first=$1; sec=$2; tro=$3;quat=$4 } if (tro == "") { $3 = search "$file2" "$first" "$file3" {print $1","$2","$3","$4} } else {print $1","$2","$3 $4}}' $file1 > $file search () { (2 Replies)
Discussion started by: kamel.seg
2 Replies

9. Programming

Help with a function call

Hi, Can anyone help me figure out the problem I'm having with a function call? I have a header file, which sets an enum: typedef enum {INFO, WARNING, FATAL} Levels; int log_event (Levels, char *fmt, ...); ..then the function is called this way: log_event(INFO, "Message text"); ... (6 Replies)
Discussion started by: Stevhp
6 Replies

10. Shell Programming and Scripting

function call

can I call a function in bash script just as in C++ while do function() done function() thanks, Steffen (3 Replies)
Discussion started by: forever_49ers
3 Replies
Login or Register to Ask a Question