My Oracle Support Banner

How to increase the default limit of BLOB datatype field size (Doc ID 2495896.1)

Last updated on NOVEMBER 14, 2022

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 to 12.2.1.4.0 [Release 12c to 12g]
Oracle Analytics Server - Version 5.5.0.0.210922 and later
Information in this document applies to any platform.

Goal

 As per the Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition the default maximum length of all fields in Oracle BI Server is 32,678 bytes. When BLOB Objects such as PDF files and JPEG images are stored in Oracle DB and downloaded in OBIEE 12C, the maximum size is always below the 32,678 bytes. How to change this default limit?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.