Search Results

Hi.

You have thrown the output away (to /dev/null), and one or two more sets wouldn'g go amiss:

Change:

typeset -i sql_ret_val1=`sqlplus -s ${ORA_CONN_STR} <<EOF > /dev/null
SET HEADING OFF...

Alternatively, you could redirect to your log file instead of /dev/null.
And not use the SPOOL command explicitly.
Like so -


$
$
$ cat tst.sh
#!/usr/bin/bash
ORA_CONN_STR="test/test"...

U can use :

sqlplus -s ${ORA_CONN_STR} <<EOF >/dev/null