Oracle8 AL: How can I use a RWDBBlob with LONG RAW or BLOB columns that hold 32k or more

Problem

---

When using RWDBBlob in my application it seems to only hold 32k of data.  Is there any way that I can get my RWDBBlob object to hold more?

---

Cause

---

The maximum blob size is used when retrieving large-sized data (LONG/LONG RAW or CLOB/BLOB). The default size is 32kb - 1.

---

Action

---

RWDBOracle8SystemHandle offers mutators for piecewise size and maximum blob size. These functions are:

size_t piecewiseSize() const;
size_t piecewiseSize(size_t size);
size_t maximumBlobSize() const;
size_t maximumBlobSize(size_t newSize);

The piecewise size is used internally when the data size is very large (LONG/LONG RAW or CLOB/BLOB). Size can be reset and retrieved through piecewise size mutators. The default piecewise size is 32kb. The maximum blob size is used when retrieving large-sized data (LONG/LONG RAW or CLOB/BLOB). The default size is 32kb - 1.

There is more information about the RWDBOracle8SystemHandle class in the Oracle8 Access Guide chapter 2.15.  It is possible to use code such as the following to set the maximum Blob size and the piecewise size to larger values. 

#code

...

#include <rw/db/or8src/or8sysh.h>

RWDBConnection cn = db.connection();

RWDBSystemHandle *aHandle = cn.systemHandle();
RWDBOracle8SystemHandle *dbLibHandle = (RWDBOracle8SystemHandle *) aHandle;
dbLibHandle->maximumBlobSize(DATA_SIZE);

dbLibHandle->piecewiseSize(DATA_SIZE);
...