Hi,
I have already using DBI module, I just wanted to explain with an example.
Let think that I want to be root user and issue some command in that case I
also need
bidirectional pipes.
su - root
Password ....
execute some commands here .
Mehmet
Sudarshan Raghavan
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
reless.com> cc:
Subject: Re: Bidirectional pipes
09/02/2003 02:27 PM
[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]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
