Resolve TimesTen Error "07006: Restricted data type attribute violation" When Accessing BLOB Content In A AWT Cache Group With VARBINARY Column (Doc ID 1666947.1)

Last updated on FEBRUARY 27, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.6.0 and later
Information in this document applies to any platform.

Symptoms

Got BLOB datatype in Oracle. Using AWT to cache that info to TT, in AWT CG, must use varbinary data type to cache those BLOB type.
when trying to update the data in TT cache group, getting the following in pro*C program when using lob descriptor to update the blob data:

EXEC SQL UPDATE TEST_BLOB SET T_BLOB = EMPTY_BLOB() WHERE ROWID = :row RETURNING T_BLOB INTO :blob;
ORA-00932: Restricted data type attribute violation

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms