Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
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
Message-ID: <F76C9B2DA2FC4C4CA0A18E288BBCBCF71026EC31@nihexchange24.nih.gov>
From: "Buchbinder, Barry (NIH/NIAID)" <BBuchbinder AT niaid DOT nih DOT gov>
To: cygwin AT cygwin DOT com
Subject: RE: Piping output from sqlplus
Date: Thu, 16 Dec 2004 15:48:15 -0500
MIME-Version: 1.0
Content-Type: text/plain
X-IsSubscribed: yes

At Thursday, December 16, 2004 3:29 PM, Chuck wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> I'm having a strange problem reading the output from sqlplus in
> Cygwin. Sqlplus is a windows command line program used to access
> oracle 
> databases. My command looks something like this...
> 
> sqlplus -s <<! | read line
> user/password AT database
> set pagesize 0 linesize 200 feedback off tab off
> select col1||chr(9)||col2
> from table;
> !
> 
> This should output one line to stdout with the two values separated
> by a tab character. The read command should read it into the variable
> $line. 
> On my Solaris system it works perfectly. In Cygwin, $line is empty.
> 
> If I remove the "read line", the output displays on the tty just fine.
> 
> I though it might be related to the line end characters so I tried
> converting them with the dos2unix filter. Didn't work. Neither did tr
> -d \\r. Both ways, $line still ends up being empty.
> 
> If I replace the "read line" with "od -c" to dump the characters, it
> shows the one line as expected.
> 
> If I redirect the output to a file, the file contains one line as
> expected. 
> 
> If I try to read the output into a variable, I get an empty variable
> 
> Any ideas?

If the output shows up OK in a file, do
VAR="$(cat file)"

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