oracle返回值问题，看看我错在哪里啊~~

ljhway

#!/bin/bash
        declare -i date
        sysdate=`date +%Y%m%d`
        count=`echo $2*10000|bc`
        date=`echo ${sysdate}+${count}|bc`
        echo $1>email.txt
        sed 's/public2/public/g'  email.txt >email2.txt
        username=`awk -F'@' '{print $1}' email2.txt`
        domain=`awk -F'@' '{print $2}' email2.txt`

#userid*************************************************************************************
userid=`sqlplus -silent "umail/umail" << END
set pagesize 0 feedback off verify off heading off echo off
select userid from email_users a,domain b  where a.domainid=b.domainid and a.username='$username' and b.DOMAINNAME='$domain';
exit;
END`
#**************************************************************************************

#business_account_id*************************************************************************************
business_account_id=`sqlplus -silent "umail/umail" << END
set pagesize 0 feedback off verify off heading off echo off
select business_account_id from business_account where user_id='$userid';
exit;
END`
#**************************************************************************************


#执行更新*************************************************************************************
set serveroutput on business_account_id=`sqlplus -silent "umail/umail" << END
set serveroutput on set pagesize 0 feedback off verify off heading off echo off
begin
update business_purchase set PURCHASE_EXPIRE_DATE=to_date('$date','yyyymmdd')  where business_account_id='$business_account_id';
if SQL %NOTFOUND then
dbms_output.put_line('没有数据更新。');
else
dbms_output.put_line('成功更新。');
end if;
end;
/
commit;
exit;
END`
#**************************************************************************************

#执行更新*************************************************************************************
business_account_id=`sqlplus -silent "umail/umail" << END
set serveroutput on set pagesize 0 feedback off verify off heading off echo off
begin
update email_users set status=0 where userid='$userid';
if SQL %NOTFOUND then
dbms_output.put_line('没有数据行更新。');
else
dbms_output.put_line('成功更新。');
end if;
end;
/
commit;
exit;
END`
#**************************************************************************************

最后两个更新怎么一直没有返回呢？高手请教下啊

err7dd

对oracle不熟,你看一下是不是那几个设置选项把输出信息给屏蔽掉了啊？
set serveroutput on set pagesize 0 feedback off verify off heading off echo off

nuclearxin

仿盛大方式对付
i have no idea
:em11: :em11: :em11: :em11:

[ 本帖最后由 nuclearxin 于 2008-7-1 13:16 编辑 ]