Shell Programming and Scripting

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

A segmentation fault is usually caused by a bug in a programme, where it attempts to access memory which it does not own.

Do you know at what stage in your script it is failing? Try adding set -x to the beginning of the script so you can trace it.

Please don't send private messages, otherwise the other members can not benefit from your experience.

Where exactly did you add it? It should display each line of the script as it is executed. What shell are you running it under? Is there no "shebang line" at the beginning of the script, e.g. #!/usr/bin/ksh?