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.

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.

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

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