Hi
I have a batch script that performs the following tasks
prepare insert statement for oracle
loop through files in a directory
read each line from the current file using dbd-csv
insert into oracle using dbd-oracle
end loop
This runs fine on Windows 2000, but when I try on NT, after reading a couple
of hundred rows I get
Error: Runtime exception
The file is only just over 1MB in size. The Win2000 box has 256MB RAM, while
the Win NT server has 512MB, so I don't think that it's a memory shortage
issue, as nothing else is running.
However, if I move the prepare statement inside the loop, it works:
loop through files in a directory
prepare insert statement for oracle
read each line from the current file using dbd-csv
insert into oracle using dbd-oracle
end loop
But I don't want to prepare a statement for every row I read. I've turned on
DBI tracing, and there doesn't seem to be anything unusual when the program
crashes. Likewise, Dprof produces an empty tmon.out file (but I may not be
running it correctly - perl -d:DProf script)
The versions of perl, dbi, dbd-oracle and dbd-csv are the same on both
systems - pretty ancient actually: 5:003, 1.14, 1.03 and 0.1023.
Does anyone have any ideas? Also, can I get later versions of the modules
that can be installed using Activestate's ppm? That's probably as good a
place to start as any
Thanks, Dan
