Perl DBI Oracle: bind an array list

2007-02-16 Thread Nitin Aggarwal
Hi, I am using bind variables for executing a select query which uses "in" operator. Following is the prototype of my code: $query = "select a from tab where b in (:1)"; @list = {"A","B","C","D"}; $list_values = join("','",@list); $DBI-> connect (..); $sth -> prepare($query); $sth-> execute ($

retrieve command data from DOS using telnet

2003-09-04 Thread Nitin Aggarwal
Hi , I am writing this code to telnet into windows machine. The code works fine on the unix machine and runs the command 'ps -ef'. On W2K I am trying to telnet into the machine and to recognize the prompt 'C:\' . but it keeps on giving the error 'time-out. I have tried different combinations of t

telnet and then run any one command on windows

2003-09-05 Thread Nitin Aggarwal
Hi , case 1: my $hostname = '10.10.2.45'; my $prompt1 = '/\>$/'; my $name = 'administrator'; my $password = 'nn'; my $string = 'net start '; my $session1 = Net::Telnet->new(Host => $hostname,) ; $session1->login(Name => $name, Password => $password, Prompt => $prompt1,); my @output = $session1->

Re: retrieve command data from DOS using telnet

2003-09-09 Thread Nitin Aggarwal
gt; Yes, his machine could very well have Telnet Server installed -- see below > > -Original Message- > From: R. Joseph Newton [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 1:37 PM > To: Nitin Aggarwal > Cc: [EMAIL PROTECTED] > Subject: Re: retrieve command d