# Toad DEBUGGER and BLOB

**URL:** <https://forums.toadworld.com/t/toad-debugger-and-blob/9205>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 4, 2010, 1:14pm UTC](https://forums.toadworld.com/t/toad-debugger-and-blob/9205 "2010-02-04T13:14:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lafontaine.m](https://avatars.discourse-cdn.com/v4/letter/l/0ea827/32.png) [@lafontaine.m](https://forums.toadworld.com/u/lafontaine.m)\
**Post date:** [February 4, 2010, 1:14pm UTC](https://forums.toadworld.com/t/toad-debugger-and-blob/9205/1 "2010-02-04T13:14:12Z")

</div>

Hi ,

I'm using TOAD Debugger to test my PACKAGES. My procedures have IN parameters. So far no problem !

But in some of my procedures I've got parameters declared has BLOB and CLOB. I don't have any problems putting in values for CLOB. But BLOB is another issue.

I can't test my BLOB parameters because if I put in TEXT, it gives me an error.

Is there a way to input value in a BLOB parameter using the debugger???

See attached file !!!

Please Help,

Marc.

 ![toad_debugger.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/c9bf0e8d46fba28e29f5291e19a1fbf764872b4f.jpeg)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 4, 2010, 1:53pm UTC](https://forums.toadworld.com/t/toad-debugger-and-blob/9205/2 "2010-02-04T13:53:54Z")

</div>



---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [February 4, 2010, 1:53pm UTC](https://forums.toadworld.com/t/toad-debugger-and-blob/9205/3 "2010-02-04T13:53:54Z")

</div>

Maybe something like:

DBMS\_LOB.CREATETEMPORARY(P\_ENVELOPE\_CONTENT, false, 0);  
DBMS\_LOB.WRITE(P\_ENVELOPE\_CONTENT, LENGTH(‘TEST’), 1, UTL\_RAW.CAST\_TO\_RAW(‘TEST’));