类似下面的方法:
fcp_login="/ "
ret_value=`sqlplus -s $fcp_login << EOF
set heading off
set feedback off
set pages 0
set trimspool on
VARIABLE x_outnum VARCHAR2(30);
EXECUTE importUserInfoDate1g(:x_outnum);
print x_outnum
exit;
EOF`
fcp_login="
ret_value=`sqlplus -s $fcp_login << EOF
set heading off
set feedback off
set pages 0
set trimspool on
set serverout off
VARIABLE x_outnum number;
EXECUTE importUserInfoDate1(:x_outnum);
print;
exit;
EOF`
直接用print才行