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/[EMAIL PROTECTED] > 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/
