-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Buchbinder, Barry (NIH/NIAID) wrote: | 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)" |
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.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBwfaHzIf+rZpn0oQRAvKQAJ9WYJ6CbGrEeDwN9lMg2fzOIGsiOgCffjyz BxriTOuv4IqT3zdFMHUesIY= =jJGJ -----END PGP SIGNATURE-----
-- 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/