# KNIME + BLOB Processing

**URL:** <https://forum.knime.com/t/knime-blob-processing/2819>\
**Category:** KNIME Analytics Platform\
**Created:** [July 9, 2013, 4:11pm UTC](https://forum.knime.com/t/knime-blob-processing/2819 "2013-07-09T16:11:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![odin](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/o/87869e/32.png) [@odin](https://forum.knime.com/u/odin)\
**Post date:** [July 9, 2013, 4:11pm UTC](https://forum.knime.com/t/knime-blob-processing/2819/1 "2013-07-09T16:11:03Z")

</div>

Hello,

Is there any way to process Oracle BLOBS being converted to HEXDUMPS in database reader node? I don't think that they are entirely the same as blob exported via&nbsp; SQL Developer is very different from the one copied from the node.

Any useful ideas?

---

<div class="post-metadata">

**Author:** ![gabriel](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gabriel/32/61386_2.png) [@gabriel](https://forum.knime.com/u/gabriel)\
**Post date:** [July 10, 2013, 8:59am UTC](https://forum.knime.com/t/knime-blob-processing/2819/2 "2013-07-10T08:59:41Z")

</div>

If found this documentation about BLOBs and HEX dumps which might be interesting to look at: [http://www.databaseteam.org/4-oracle/2265f45dd8dbd78b.htm#.Ud0FaW0cUcE](http://www.databaseteam.org/4-oracle/2265f45dd8dbd78b.htm#.Ud0FaW0cUcE)

However, if you planning to execute this in KNIME's Database node you must ensure that each statement (within one row of the script) can be executed as a JDBC command, for example PL/SQL with its keywords such as END / BEGIN won't work that way, see [here](https://forum.knime.com/forum/knime-general/call-a-plsql-function-out-of-knime) for further details.

---

<div class="post-metadata">

**Author:** ![odin](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/o/87869e/32.png) [@odin](https://forum.knime.com/u/odin)\
**Post date:** [July 10, 2013, 10:48am UTC](https://forum.knime.com/t/knime-blob-processing/2819/3 "2013-07-10T10:48:27Z")

</div>

Thanks! Is there any plan to create node for blob exports / conversions? Just asking.

---

<div class="post-metadata">

**Author:** ![gabriel](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gabriel/32/61386_2.png) [@gabriel](https://forum.knime.com/u/gabriel)\
**Post date:** [July 10, 2013, 10:53am UTC](https://forum.knime.com/t/knime-blob-processing/2819/4 "2013-07-10T10:53:00Z")

</div>

The Database nodes support BLOBs which can also be "manipulated" using the File Handling package available at KNIME Labs on the standard KNIME update site.

---

<div class="post-metadata">

**Author:** ![odin](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/o/87869e/32.png) [@odin](https://forum.knime.com/u/odin)\
**Post date:** [July 10, 2013, 11:31am UTC](https://forum.knime.com/t/knime-blob-processing/2819/5 "2013-07-10T11:31:23Z")

</div>

Works great, thanks.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:18pm UTC](https://forum.knime.com/t/knime-blob-processing/2819/6 "2023-06-23T20:18:21Z")

</div>