Following is d code snipet

#!/bin/ksh
retVal=`sqlplus -s user/passwd\@oracle_sid <<EOF
SET SERVEROUTPUT ON SIZE 100000
DECLARE
STATUS_VALUE VARCHAR2(1);
BEGIN
SELECT temp1 INTO STATUS_VALUE FROM sai;
DBMS_OUTPUT.PUT_LINE(STATUS_VALUE);
END;
/
exit;
EOF`
echo "Return Value Is=$retVal"
if [[ $retVal = "N" ]]; then
echo "Refresh is still going on"
else
echo "Refresh is done!! You can start the make"
fi

The output is :
Return Value Is=N

Refresh is done!! You can start the make


Though the value of retVal is "N"...why its going in to else part ??

TIA.

Dont double post..

If not working...pls help:URGENT

No duplicate or cross-posting, please read the rules.

Thread closed.