This is the mail archive of the cygwin mailing list for the Cygwin project.

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: Piping output from sqlplus

Hash: SHA1

Buchbinder, Barry (NIH/NIAID) wrote:
| At Thursday, December 16, 2004 3:29 PM, Chuck wrote:
|>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
|>databases. My command looks something like this...
|>sqlplus -s <<! | read line
|>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
|>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
|>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)"

That may work but it misses the point. I'm writing a script and I want
it to work on Cygwin and unix.

BTW the shell I'm using is ksh.

Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird -


-- Unsubscribe info: Problem reports: Documentation: FAQ:

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]