hI,
Pls consider the following shell script

#!/bin/csh -f

sqlplus tkyte/tkyte <<"EOF" > tmp.csh
set serveroutput on
declare
a number:=5;
begin
dbms_output.put_line( 'a:='||a );
end;
/
spool off
"EOF"

The above script does the followin
1)it connects to oracle.
2)It reads the simple pl/sql programming till "EOF" and puts that code in a file called tmp.csh
But when i execute the above script ,The pl/sql code is not getting transfered into the specified file.
If any thing is wrong in the above script pls correct me.

cheers
RRK

Try below code

#!/bin/csh -f

sqlplus tkyte/tkyte << "EOF"
set serveroutput on
declare
a number:=5;
begin
dbms_output.put_line( 'a:='||a );
end;
/
spool off
"EOF" >> tmp.csh 2>&1