On Fri, 20 Dec 2002, Niraikalai Vijay wrote:
> When I use perl 5.6 to run a perl program with select
> sql in it, I am getting following error
>
>
> DBD::Oracle::st fetchrow failed: ORA-24345: A
> Truncation or null fetch error occurred (DBD ERROR:
> ORA-01406 error on field 2 of 2, ora_type 2) at...
>
>
> But if I use perl5.05, the same perl program works
> fine and returing result set from the sql select.
>
> Can any one tell me why I am seeing this problem
> with perl 5.6 & not perl5.05
Without being able to see the code, it would be difficult. Without more
information on your test environment, it is more difficult still.
Are the different instances of Perl on the same machine? If so, are the
DBI and DBD::Oracle libraries built against Perl 5.5 instead of 5.6? It
might be useful to check the version of your DBI & DBD libraries, to see
if they differ for the two Perl instances. If I'm on the right track (an
open question :), it might help to rebuild DBI &/or DBD::Oracle for your
newer copy of Perl.
Other ideas:
* are you running with -w and 'use strict'?
* do you get any other errors?
* if the instances are on different machines, can the failing machine
otherwise issue sql queries? (maybe that error message is a funny way
of saying it can't establish a connection...? </grasping>
But like I say, we need more info in order to help you.
--
Chris Devers [EMAIL PROTECTED]
WARNING:
Reading this fortune can affect the dimensionality of your
mind, change the curvature of your spine, cause the growth
of hair on your palms, and make a difference in the outcome
of your favorite war.
_______________________________________________
Boston-pm mailing list
[EMAIL PROTECTED]
http://mail.pm.org/mailman/listinfo/boston-pm
