Niraikalai, you're sure to get better responses if you respond to the list
rather than just to the person who took a stab at your question. I'm
hardly the most qualified person around here :)
On Fri, 20 Dec 2002, Niraikalai Vijay wrote:
> I have different instances of perl on the same m/c.
>
> I checked the perl @INC libraries, noticed two things
>
> perl5 uses DBI 1.06 and perl5.6 uses DBI 1.24.
>
> Looks like I haven't rebuilt the DBD::Oracle with
> perl5.6 as Oracle.pm in perl5.6 @INC library has old
> timestamp than perl5.6 binary file.
>
> Answer to your other ideas:
>
> - I am not using -w option and not using 'use
> strict'
>
> - I don't get any other errors. All the SQL selects
> except this one are executing fine
>
> Thanks for the input.
>
> I will rebuild Oracle.pm and try to run the same
> script again.
Ok, so it looks like rebuilding the library will help you, but it would
also be a good idea to always -- *always* -- run your code with warnings
("#/path/to/perl -w" or, on newer versions, "use warnings;") and under
strict mode ("use strict;"). These two pragmas will almost always make
your code more robust & easier to diagnose when things break down. (In
addition, CGI scripts should always use taint mode ("#/path/to/perl -T")
to protect against risky web client inputs; I have no idea if you're doing
a CGI script here, but just in case...).
"Faster, easier is the way without use strict, warnings, & taint; more
seductive is it, but not the True Path these are." :)
--
Chris Devers [EMAIL PROTECTED]
Chocolate chip.
_______________________________________________
Boston-pm mailing list
[EMAIL PROTECTED]
http://mail.pm.org/mailman/listinfo/boston-pm
