How do I check the version of DBI and DBD modules in
my perl environment?
Also, can anyone point me to the place where bug fixes
for various releases are kept?
I am having trouble with pulling data out of oracle
and storing it in sybase. Upon inserting into sybase,
I get intermittent errors indicating a syntax error
relating to placement of quotes, but I am sure that
there no quotes since I stripped them out. Also, the
statements that cause the sybase syntax errors run
fine when applied interactively through isql.
About 1 in 20 insert statements fail, so I really
doubt that there is a syntax error.
I am unable to use the bind routines for the insert
due to the fact that one of the columns is datatype
text and place holders are not allowed for text
columns.
The intermittent nature of the error makes me think
that this is not a perl coding issue but some kind of
driver bug or incompatibility between modules.
I am using:
use 5.004;
use strict;
use DBI;
use DBI qw(:sql_types);
use Getopt::Std;
use Time::Local;
use File::Basename;
use vars qw($opt_R);
Any ideas for dealing with this would be much
appreciated.
regards,
David
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
