Shell中如何取得Procedure的返回值
Shell中要取得Procedure的返回值,可以把Procedure的返回值输出到缓冲区,然后
重定向到别的命令得到,例子如下:
1.执行Procedure的脚本
callPLSQL.csh
---------------------------------------------
#!/bin/csh -f
#Created by yaogao@gmail.com
sqlplus -s username/password@DB <<EOF
variable returncode varchar2(2);
execute ProcedureName(:returncode );
print returncode;
---------------------------------------------
2.取得返回值的脚本
Test.csh
---------------------------------------------
#!/bin/csh -f
#Created by yaogao@gmail.com
set returncode=`./callPLSQL.csh | tail -n 2`
if( $returncode == 0 ) then
echo 0;
else
echo 1;
endif
---------------------------------------------
Shell中要取得Procedure的返回值,可以把Procedure的返回值输出到缓冲区,然后
重定向到别的命令得到,例子如下:
1.执行Procedure的脚本
callPLSQL.csh
---------------------------------------------
#!/bin/csh -f
#Created by yaogao@gmail.com
sqlplus -s username/password@DB <<EOF
variable returncode varchar2(2);
execute ProcedureName(:returncode );
print returncode;
---------------------------------------------
2.取得返回值的脚本
Test.csh
---------------------------------------------
#!/bin/csh -f
#Created by yaogao@gmail.com
set returncode=`./callPLSQL.csh | tail -n 2`
if( $returncode == 0 ) then
echo 0;
else
echo 1;
endif
---------------------------------------------