Hi,

I am using the below code to get a numeric value from oracle to unix variable:

BD_RC_CNT=`sqlplus -s ${WMD_DM_CONNECT} <<EOF
set heading off
set pagesize 0
Select count(*) 
from wmd_bad_data 
where proc_id = ${PROC_ID} 
and file_id = ${FILE_ID} 
and file_dt = to_date(${DATADATE},'yyyymmdd');
exit
EOF`

$ echo $BD_RC_CNT
6

did you try

...
Select trim(count(*)) ...
...

Hi
try this: mind the spaces: "read|space|BD_RC_CNT|space|<|space|<( etc..."

read BD_RC_CNT < <(sqlplus -s ${WMD_DM_CONNECT} <<EOF
set heading off
set pagesize 0
Select count(*) 
from wmd_bad_data 
where proc_id = ${PROC_ID} 
and file_id = ${FILE_ID} 
and file_dt = to_date(${DATADATE},'yyyymmdd');
exit
EOF)

Check whether you have tab in BD_RC_CNT

echo "$BD_RC_CNT"

Thanks, Both the solutions worked perfectly. And yes when i issued the command echo "$BD_RC_CNT" it showed as below

$ echo "$BD_RC_CNT"
         6

It might be single tab, space and 6. You can check that using cat

echo "$BD_RC_CNT" | cat -vet

Agreed with CTSGNB u can filter this in oracle itself using trim...