Search Results

Last suggestion worked :) thanks

sorry about that .. done as attachments

cognos@sec-dev-sun04 : cat -n ./monie_test.sh
1 !/bin/sh
2 ###############################################################################
3 #set -vxf
4
5 ...

edited my post as per u :confused:

This is my script ..i tried in two ways as you mentioned.
Also listed is the errors i am getting
it would be really helpful if you could throw some insight here as u seem to be really good at...

thanks... but i am using single quotes in my script

code :

TODAY=$(date)
ORACLE_HOME=/opt/oracle/product/9.2.0
ORACLE_SID=$1
echo "Date is Fridayyyyy: $TODAY"
x=$($ORACLE_HOME/bin/sqlplus -s report/report@$ORACLE_SID <<EOF
set heading off...

it says invalid character. probably due to the quotes in the where clause of select query.

thanks so much .. ! ur code worked like magic :b:
thanks a lot.

---------- Post updated at 09:25 PM ---------- Previous update was at 08:57 PM ----------

I have another problem now ..
It...

thanks for the code . but both of them throws the following error on my system

Date is Fridayyyyy:
Count = ERROR:
ORA-01741: illegal zero-length identifier

it does not work .. can this be achieved without a pl sql block
and using just a select query and a linux variable .

Yeah the code works gud. But the value of x and var turns out null.
Any idea why.. infact var should atleast be 0 since its been initialized

Thanks for the prompt reply. Variable still displays nulls. Is thr something major i am missing.
( Am a total novice in this )

I tried searching the forum for similar posts but its closed now.
Would appreciate any help on this.
I am trying to capture return value from a select query into a variable.
DB is Oracle
I am...