I need to execute a shell script that in turn executes a stored procedure(eg. select * from temp) . Now I want to get the result of the stored procedure or the select statement output and store that result in a file. How to do this?

I am working in korn shell.

Depending on the tool you use you might be able to specify a flag for input and output
e.g. isql -i infile -o outfile
else use shell redirect
e.g. isql <infile >outfile 2>&1
e.g. isql <<EOF >outfile 2>&1
select * from temp
go
EOF

use these statements in ur script

isql -Uuser_name -Ppassword<<!RUN>>outputfile_name
select * from temp
go
!RUN

after this execute the script
as
sh filename