sqlplus and end-of-line problem in shell script code

[Dr. Volker Zell]

>>>>> Thomas Porschberg writes:

    > Hi,
    > I want to use our shell script collection which includes sqlplus calls
    > under Cygwin.
    > I have the following problem with this code snippet:

    > #!/bin/bash

    > RESULT=`sqlplus -s myuser/mypasswd@MYDB <<EOF
    > SET FEEDBACK OFF;
    > SET PAGESIZE 0;
    > SELECT '42' FROM DUAL;
    > EOF`

    > if test "$RESULT" = "42" ; then
    > echo "Result is 42..."
    > else
    > echo "Result is not 42 ??!"
    > fi

    > When I run the script on UNIX it prints "Result is 42..." which is OK.
    > When I run the script under Cygwin the result is: "Result is not 42??!"

This is what I just got with your code against the latest Oracle 10g
database on Windows XP:

./checkSQLPLUS.sh 
Result is 42...

Ciao
  Volker


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/