|
|
Output Parameter value not displaying
03-17-2010
Output Parameter value not displaying
#!/bin/bash
###############################################################################
## Script : UpdateBatchNumbers.sh
## Author : Speridian
## Installation:
## Created : 16/03/2010
#
## Summary : Calls the StoredProcedure that will divide the entire records in batches
## Location of this file: In Dev Env:/apps/siebel/DevNew2/siebsrvr/MONTHLY/Working
## Revision History
## Date Revised By SIR # Description of Change
## -------- ------------------------- ------------- ----------------
###############################################################################
. ./UpdateBatchNumberEnvironment.env
#SHELL_START_TIME=`date`
#SHELL_NAME=`basename $0 | cut -d'.' -f1`
#DATE_VARIABLE=`date +%y%m%d%H%M%S`
#LOG_FILE_NAME=${SHELL_NAME}_${DATE_VARIABLE}.log
#LOG_FILE=${MONTHLY_LOG_FILE_DIR}/${LOG_FILE_NAME}
echo "**************************************************START BATCH NUMBER UPDATE********************************************************" > ${LOG_FILE}
var=`sqlplus -s ${USER}/${PASSWD}@${DATABASE} <<END
set serveroutput on
SET HEADING OFF
SET LINESIZE 500
SET PAGES 0
SET RECSEP OFF
SET VERIFY OFF
SET SHOWMODE OFF
SET ECHO OFF
SET FEEDBACK OFF
SET SPACE 0
SET TAB OFF
var batchrange char(200)
execute BATCHNUMBERPARAM('EIM_ORG_EXT_XM',16250,:batchrange)
exit;
END
`
echo 'var:'
echo $var
03-17-2010
. Below is the codesqlplus -s ${USER}/${PASSWD}@${DATABASE} << EOF > BatchRange.txt
SET SERVEROUTPUT ON
SET HEADING OFF
SET LINESIZE 500
SET PAGES 0
SET RECSEP OFF
SET VERIFY OFF
SET SHOWMODE OFF
SET ECHO OFF
SET FEEDBACK OFF
SET SPACE 0
SET TAB OFF
exec SIEBEL.BATCHNUMBERPARAM('EIM_ORG_EXT_XM',16250)
EOF
# Reading the File and output file content to stdout
while read reslt_line
do
echo "==>"$reslt_line
done < BatchRange.txt|
|
|
|