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 oracle-instantclient11.2-odbc-1

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 an

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

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

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 DBD::Or

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