how BIP job that retrieves data from an Oracle Database table containing a BLOB column — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how BIP job that retrieves data from an Oracle Database table containing a BLOB column

in BI Publisher Learning Center

We have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integration, we need to encode (or encrypt, if possible) the BLOB data into Base64 format within the SQL query or as part of the BIP data model.
Questions/Requirements:
1.What is the recommended approach to encode a BLOB column to Base64 format in Oracle SQL, so that the output can be consumed by BIP and downstream systems?
2.Are there built-in Oracle functions or packages that support BLOB-to-Base64 encoding natively?
3.If encryption is also required, what are the best practices or supported methods for encrypting BLOB data before or after Base64 encoding for use in BIP jobs?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!