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,

Reply via email to