Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Octect stream in PLSQL

4004223Jun 26 2019 — edited Jun 28 2019

Problem Summary

---------------------------------------------------

Octect stream in PLSQL

Problem Description

---------------------------------------------------

we have to consume a json service response , which has an octect stream as below. octet stream is a pdf file .

we can store the octet steam into a table BLOB column, how do we convert this content and get the pdf file .

Are there any API available ? sample octet stream is attached.

Error Codes

---------------------------------------------------

none

Problem Category/Subcategory

---------------------------------------------------

Application Development (SQL, Wrong Query Results, PLSQL, XML Database, JSON, XDK, JVM, Pro*C, OCI, OCCI, XA)/PL/SQL

example stream as below :  I have truncated part of the below stream .

<data contentType="application/octet-stream" contentLength="183036">JVBERi0xLjYKJfbk/N8KMSAwIG9iago8PAovVHlwZSAvQ2F0YWxvZwovUGFnZXMgMiAwIFIKL

BREY+IDwyRDI1RTA0OTc5NTFGMkQ3OEJCNzMyRjFFMDNGNkFERj5dCj4+CnN0YXJ0eHJlZgoxNzc4MzgKJSVFT0YK</data>

Comments
Post Details
Added on Jun 26 2019
7 comments
1,230 views