i ve been struggling for 2 days now and cant figure out the soluton.

this is my whole script

sqlplus SIEBEL/SIEBEL@oltpsia << EOF
set serveroutput on size 1000000
set heading off
set feedback off
Insert into EIM_ZIPCODE_BADEIM (select sysdate, 'TOPONOMASTICA','','', c.* From EIM_ZIPCODE c where c.if_row_stat not in ('IMPORTED','DUP_RECORD_EXISTS'));
commit;
EXIT
EOF
#echo $?
if [ $? = 0 ]; then echo "OK" else echo "Errore" fi


the sql is properly executed but the if condition not, and i keep receiving the error message "unexpected end of file"

Where is the error, please help me out

BR valerio

Well, for starters,is invalid. Remove the space before EOF.

Also, is this bash, ksh, what?

it's bash.

Did the << EOF to <<EOF change fix it?

You are missing a semicolon. Try


if [ $? = 0 ]; then echo "OK" else echo "Errore" ; fi