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

Article ID: 1133
Last updated: 31 Jan, 2008
Article ID: 1133
Last updated: 31 Jan, 2008
Revision: 1
Views: 3544
Posted: 25 Sep, 2001
by Dean J.
Updated: 31 Jan, 2008
by Dean J.
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);
...

This article was:   Helpful | Not helpful
Report an issue
Article ID: 1133
Last updated: 31 Jan, 2008
Revision: 1
Views: 3544
Posted: 25 Sep, 2001 by Dean J.
Updated: 31 Jan, 2008 by Dean J.
Also listed in


Others in this category