This is the mail archive of the
cygwin
mailing list for the Cygwin project.
Re: sqlplus and end-of-line problem in shell script code
- From: "Dr. Volker Zell" <Dr dot Volker dot Zell at oracle dot com>
- To: cygwin at cygwin dot com
- Date: Fri, 29 Sep 2006 11:35:43 +0200
- Subject: Re: sqlplus and end-of-line problem in shell script code
- References: <20060929102628.49430820@porschberg.osp-dd.de>
>>>>> 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/