Re: odbc_lob_read chunk is short

2013-09-06 Thread Martin J. Evans
On 05/09/13 20:28, Mike Grau wrote: Hello, I am completely new at this, but I am trying to read a BLOB in chunks via ODBC in Oracle 11g using DBD::ODBC-1.43, unixODBC-2.3.1 and oracle-instantclient11.2-odbc-11.2. I can read an entire BLOB in one read and write it to the filesystem, but I really

RE: odbc_lob_read chunk is short

2013-09-06 Thread Martin Gainty
odbc_lob_read(sth, colno, buf, length, \%attrs) where \%attrs can contain TYPE = SQL_type. http://www.nntp.perl.org/group/perl.dbi.dev/2010/07/msg6140.html where Type should be SQLBINARY http://www.nntp.perl.org/group/perl.dbi.dev/2010/09/msg6258.html It turns out I was mistaken as

Re: odbc_lob_read chunk is short

2013-09-06 Thread Mike Grau
Martin Gainty wrote: odbc_lob_read(sth, colno, buf, length, \%attrs) where \%attrs can contain TYPE = SQL_type. http://www.nntp.perl.org/group/perl.dbi.dev/2010/07/msg6140.html where Type should be SQLBINARY http://www.nntp.perl.org/group/perl.dbi.dev/2010/09/msg6258.html Thanks Martin,

Re: odbc_lob_read chunk is short

2013-09-06 Thread Mike Grau
Martin Gainty wrote: odbc_lob_read(sth, colno, buf, length, \%attrs) where \%attrs can contain TYPE = SQL_type. http://www.nntp.perl.org/group/perl.dbi.dev/2010/07/msg6140.html where Type should be SQLBINARY http://www.nntp.perl.org/group/perl.dbi.dev/2010/09/msg6258.html Thanks Martin,

Re: odbc_lob_read chunk is short

2013-09-06 Thread Martin J. Evans
On 06/09/13 09:18, Martin J. Evans wrote: On 05/09/13 20:28, Mike Grau wrote: Hello, I am completely new at this, but I am trying to read a BLOB in chunks via ODBC in Oracle 11g using DBD::ODBC-1.43, unixODBC-2.3.1 and oracle-instantclient11.2-odbc-11.2. I can read an entire BLOB in one read

Re: odbc_lob_read chunk is short

2013-09-06 Thread Martin J. Evans
On 06/09/2013 17:52, Martin J. Evans wrote: On 06/09/13 09:18, Martin J. Evans wrote: On 05/09/13 20:28, Mike Grau wrote: Hello, I am completely new at this, but I am trying to read a BLOB in chunks via ODBC in Oracle 11g using DBD::ODBC-1.43, unixODBC-2.3.1 and