X-Spam-Check-By:	sourceware.org
X-Mailer:	21.4 (patch 19) "Constant Variable" XEmacs Lucid (via feedmail 10 I)
To:	cygwin AT cygwin DOT com
Subject:	Re: sqlplus and end-of-line problem in shell script code
References:	<20060929102628 DOT 49430820 AT porschberg DOT osp-dd DOT de>
From:	"Dr. Volker Zell" <Dr DOT Volker DOT Zell AT oracle DOT com>
Date:	Fri, 29 Sep 2006 11:35:43 +0200
In-Reply-To:	<20060929102628.49430820@porschberg.osp-dd.de> (Thomas Porschberg's message of "Fri, 29 Sep 2006 10:26:28 +0200")
Message-ID:	<828xk3ggls.fsf@vzell-de.de.oracle.com>
User-Agent:	Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (cygwin32)
MIME-Version:	1.0
X-IsSubscribed:	yes
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Unsubscribe:	<mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com

>>>>> 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 AT 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/

- Raw text -