Toad DEBUGGER and BLOB

Toad for Oracle
1

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
toad_debugger.jpeg1005×526 109 KB

3

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’));