Unable to retrieve data from shell when connected to Oracle

view story

http://www.unix.com – I am trying to get the data from oracle table to a variable I have tried the below code Code: #/usr/bin/sh         echo " I am in correct loop"         SPOOL_FILE=/app/scripts/alt.lst       sqlplus /nolog  <<END_SQL         connect bindu/bindu@gis         whenever sqlerror exit failure rollback;         set serveroutput on         set termout on         set trimspool on         SPOOL $SPOOL_FILE (HowTos)