Shell Programming and Scripting

hi,

I have tried this script but this time i did not got the expected result, instead am getting the output diffrently

when i ran the follwoing script

export v_test=0
v_test=$(sqlplus -s apps/apps <<END
set feedback off
set heading off
select 6 from dual;
exit;
END)
echo out put is $v_test

then the output is :

sh test.sh
out put is Usage: SQLPLUS [<option>] [<user>[/<password>] [@<host>]] [@<startfile> [<parm1>] [<parm2>] ...] where <option> ::= { -s | -? } -s for silent mode and -? to obtain version number


but i was expecting:

out put is 6

can you please let me know what to do

Hi,
Iam not pretty sure,can u able to run the commands separately.
first sqlplus -s apps/apps like that

how about this

Code:

sqlplus -s apps/apps <<END
set feedback off
set heading off
select 6 from dual;
exit;
END
v_test=$?
echo output is $v_test

Hi andryk,
the variable v_test=$? wont catch the value 6 it will catch only the return status of the previous command.

tell what error u got? did u check your sql separatly if it is working correct??
I have so many scripts which does like this .. I dont know what you are doing wrong?..

v_syse=`${ORACLE_HOME}/bin/sqlplus -s user_id/password <<END
select '6' from dual ;
EXIT;
END`

sorry, didnt look at the question!!!
But why dont you redirect the result to a file and work from there

Code:

sqlplus -s apps/apps <<END
set feedback off;
set head off;
spool /tmp/somefile.result;
select 6 from dual;
exit;
END
echo output is 
cat /tmp/somefile.result
rm /tmp/somefile.result

NLS=`${ORACLE_HOME}/bin/sqlplus -s<<EOF
/ as sysdba
set heading off
select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
EOF`


echo $NLS


works fine here