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.
08-08-2008
