Rogue Wave Knowledge Base
Search:    
Browse by category:
Knowledgebase | Glossary | Ask a Question |

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
Revision: 1
print  Print
share  Share
Views: 3537
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


Also listed in
folder SourcePro -> Releases -> Edition 1 SP
folder SourcePro -> Releases -> Edition 2 SP
folder Legacy -> .h++

Prev     Next
How can I use RWDBOSql to execute an Oracle stored procedure?       Oracle AL: How can I use a RWDBBlob with LONG RAW columns that...

Others in this category
b Returning and processing multiple result sets from an Oracle stored procedure
b In Source Pro DB, why do I have to explicitly link in to my application an access module specific object file?
b Why can't I use a single string between static and shared libraries in RWDBManager::database constructor?
b On Solaris 10 using an RWDBSelector in the context of compound expressions showing memory leak when a throw occurs
b How can I use RWDBOSql to execute an Oracle stored procedure?
b Oracle AL: How can I use a RWDBBlob with LONG RAW columns that hold 32k or more
b Oracle AL: Can I use RWDBStoredProc with an Oracle stored procedure that has more than 32 parameters?
b SourcePro DB examples core dump
b SourcePro Ed 9 : Setting Oracle specific timestamp to FALSE results in incorrect date being sent to the database
b SourcePro stored procedure execution with input/output parameter is 4 to 5 times slower in system time than the native OCI
b Store and Read XMLTYPE Column with DB Access Module for Oracle
b Using a SourcePro DB Access Module with more than one version of a Database Client
b Data corruption when fetching data with some versions of Oracle8 client