Ronald J Kimball wrote:
Are you sure the tables you're reading from aren't actually empty?
Thats it! I forgot to commit the changes in the sqlplus window. So the
'select' statements were working fine there, but obviously there was
nothing actually in the tables.
The only change in the code
rohit bhute [mailto:[EMAIL PROTECTED] wrote:
> [snip]
>
> Whih is correct. However, when I change the query to read any of the
> tables, it shows just "Connected" and "Disconnected".
>
> Any idea of where I'm going wrong?
You've showed us the code that works, but not the code that doesn't...
Add some "or die" clauses to your prepare and execute statements, like
you did to your connect.
On 8/21/06, rohit bhute <[EMAIL PROTECTED]> wrote:
This is my code.
#! C:\Perl\bin\perl.exe -w
use strict;
use DBI;
use CGI qw(:standard);
use CGI::Carp ;
use CGI::Carp 'fatalsToBrowser' ;
print
This is my code.
#! C:\Perl\bin\perl.exe -w
use strict;
use DBI;
use CGI qw(:standard);
use CGI::Carp ;
use CGI::Carp 'fatalsToBrowser' ;
print header;
print start_html('IDS');
my $dbh = DBI->connect( 'dbi:Oracle:ilclpdv3',
'rbhute',
'rbhute',