Hello folks,
Please find the below codesample5.sh -> filename)

echo "Selecting dat afrom Cause code"
echo "set appinfo Causecode
$preamble
set serveroutput on size 10000
select * from RMI003_CAUSE_CODE /" | sqlplus -S $username@$hoststring/$password >> test2.dat

When i tried executing the code using "SH" i am getting a file "test2.dat",but the file doesn't have any records. Please suggest me where i am wrong.


Thanks,
Sundar.

Try this script

X=`sqlplus -s user/password@host <<eof
set serveroutput on;
set feedback off;
set linesize 1000;
select * from tablename;
EXIT;
eof`

echo $X>testing.dat

Here in X you will get the output and after exiting from sql session put that output in some file.May be this will solve your problem.....

What is the meaning of the slash character (/)? Its placement is wrong in your code. You either need to put it on a line by itself of replace it with a semicolon ( ; ).

tmarikle:

Actually old form of Oracle sql statments were in a block ended by a slash. If he added a \n character it would work.

This is legal SQL, try it:

select 1 from dual
/

Yes / is absolutely right but that is required when pl/sql block is used from shell script.here ; would have done the job.

Jim,

I must not have been as clear as I thought, that's actually what I was trying to communicate to the OP. I was trying to point it out but also prompt an answer so that perhaps the OP could see his own error. Oh well, perhaps next time I'll be more plain.

Thomas