[EMAIL PROTECTED] wrote:
Hello, I tried it to use with sqplus username/passwd
after this I like to send some sql commands and get their results but at some point system blocks and I don't get anything
$ph = open2 (\*Reader , \*Writer, "sqlplus xxx/yyy");
print Writer , "desc user_tables;\n"; while (<Reader>) { print ; }
.... (it hang somewhere here )
The IPC::Open2 manpage mentions a warning on similar lines. I am not entirely sure about using this module with sqlplus and any associated caveats, you might want to google on this topic. I guess you are using an oracle database, why not use DBI for this purpose. You will interested in these modules
DBI (perldoc DBI)
DBD::Oracle (hope I got the name right. perldoc DBD::Oracle, you can download and install this module from http://search.cpan.org)
print Writer , "desc dba_tables;\n"; while (<Reader>) { print ; }
Sudarshan Raghavan <[EMAIL PROTECTED] To: [EMAIL PROTECTED] reless.com> cc: Subject: Re: Bidirectional pipes 09/02/2003 11:21 AM
[EMAIL PROTECTED] wrote:
Hi all, I wonder how can I open pipe to STDIN and STDOUT of a process ?
perldoc IPC::Open2
If you need a handle to STDERR perldoc IPC::Open3
Tnx. Mehmet
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
