HI admin unix,

I'm from indonesia that currently work as system admin for server under AIX/UNIX environment.

I have some trouble when running script as follow :

##
vdate()
{
sqlplus -s ${MMUSER}/${PASSWORD} <<-eot|grep -v '^$'
set heading off feedback off
select to_char(vdate,'YYYYMMDD') from period;
eot
}

cek1()
{
sqlplus -s ${MMUSER}/${PASSWORD}@${ORACLE_SID}<<-eot|grep -v '^$'
set heading off feedback off echo off
SELECT count(1)
FROM item_loc a
LEFT OUTER JOIN
item_supp_country b ON a.item = b.item
AND a.primary_supp =b.supplier
WHERE a.item_parent IS NOT NULL
AND loc = (SELECT like_store
FROM store_add)
AND supp_pack_size IS NULL
AND primary_supp IS NOT NULL;
eot
}

cek2()
{
sqlplus -s ${MMUSER}/${PASSWORD}@${ORACLE_SID}<<-eot|grep -v '^$'
set heading off feedback off echo off
SELECT TRIM (COUNT (1))
FROM (SELECT DISTINCT item
FROM item_loc il
WHERE loc IN (SELECT like_store
FROM store_add) AND item_parent IS NOT NULL
MINUS
SELECT DISTINCT item
FROM vat_item vat);
eot
}

CplkStore()
}
sqlplus -s ${MMUSER}/${PASSWORD}@${ORACLE_SID}<<-eot|grep -v '^$'
set heading off feedback off echo off

SELECT store||'-'||like_store
FROM store_add;
eot
)

recCplkStore=`CplkStore`
recCek1=`cek1`
recCek2=`cek2`

textCplkStore="`date '+%h %d %r'`: Copy Like Store: "
textCek1="`date '+%h %d %r'`: Data Item/Loc Supplier belum lengkap : ${recCek1}"
textCek2="`date '+%h %d %r'`: Data Item VAT belum lengkap: ${recCek2}"

echo "Copy like Store: `echo ${recCplkStore}|awk -F '-' '{print $1}'` from store `echo ${recCplkStore}|awk -F '-' '{print $2}'`"
echo "testing"
if [ "${recAfter}" != "0" ]
then
echo "There are some errors found in MPP_STG_MSM20_PSH table!"
exit 1
else
echo "MSM20 finished successfully."
exit 0
fi

the result is :
"Segmentation Fault (core dump)"

i already unlimited coredumpsize, memory size but error is still remain :
"Segmentation fault"
(coredump is already gone)

Can anyone help me for that ?

Thanks.

Cahyo