Ok thanks for that. I will try to get it in Trunk this week sometime but
for sure it will be in 1.23 when ever that comes out :-)
cheers
John Scoles
Chris Underhill wrote:
I have blob that is stored in an Oracle table that, with a chunk size
of 4096 bytes, requires 2 chunks. The second chunk however is one byte
long and contains a zero (ASCII 48). The data is read in using
ora_lob_read, and so if you follow the method in documentation for
DBD::Oracle, i.e., something like
while( my $data = $dbh->ora_lob_read( $char_locator, $offset,
$chunk_size ) ) {
print STDOUT $data;
$offset += $chunk_size;
}
you will miss this last byte as $data will contain 0. As the data I'm
interested is compressed, this causes it to be corrupted and so my
code barfs later on.
I've attached a simple patch against DBD::Oracle 1.22.
Cheers,
Chris,