CODEWITHSUNDEEP
oracle-databaseblob
Mr. Blob
Mr. Blob

Reputation: 11

Read a few megabytes from a BLOB in Oracle

I wish to extract a sub-BLOB (a few MBs) from a BLOB in Oracle.

The question "read first 1kb of a blob from oracle" doesn't help me, since I need to get more bytes than DBMS_LOB.SUBSTR can give me (it returns RAW, which supports only a few thousand bytes).

Upvotes: 1

Views: 436

Answers (1)

Janek Bogucki
Janek Bogucki

Reputation: 5123

Use DBMS_LOB.READ(lob_loc, amount, offset, buffer)

Upvotes: 1

Related Questions