Hi,
Your example is good.. I tried running the example for a shell script on HP-UX
test.sh
#!/usr/bin/sh
echo HELLO

This works fine with exit code 0.

If I change it to
#!/usr/bin/sh
echo HELLO > /test/log.txt
cd /test/upload
export ORACLE_HOME=/product/oracle
sqlplus test/test@TESTDB @/test/upload/test.sql

test.sql contains

BEGIN
INSERT INTO msg_tbl values('hi there inserted');
commit;
END;
/
quit;

For this script I have a problem. Although the commandline shows PL/SQL procedure executed successfully, no rows are inserted to the table. However the message HELLO is found in log.txt..
Any pointers on what exactly could be the problem.
Not able to figure it out since the log.txt is getting created and it says proc executed but i dont see any rows.