My Oracle Support Banner

Unable To Select Table From REST Enabled Data Source In Download BLOB Column Property Of Report (Doc ID 2752141.1)

Last updated on MARCH 16, 2021

Applies to:

Oracle Application Express (APEX) - Version 19.2 and later
Oracle REST Data Services - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

Using the REST Enabled SQL feature of ORDS.
Having issues with Download BLOB data in interactive report. The table on remote data source is not visible in parsing schema and hence cannot set the properties.

Able to query the data and make reports. So used this technique when the data is not BLOB and this worked.
Only issue is with BLOB attributes. Unable to retrieve tables from remote database in BLOB attributes section when trying to make column as BLOB Download.

Cause

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
Symptoms
Cause
Solution


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