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!

How to print blobs and clobs to console

652974Sep 29 2009 — edited Dec 13 2011

Hi All

I have a blob that I want to print to the console and inspect the value. I have tried to use dbms_output.put_line (i.e. dbms_output.put_line('the supplied input is '||byBlob);)function but I keep getting the error

Error(13,22): PLS-00306: wrong number or types of arguments in call to '||'

I suppose that the dbms_output.put_line does not take a blob as an arguement, but I was wondering if there was another function that achieves the same thing as dbms_output.put_line

thanks guys

This post has been answered by Sven W. on Sep 29 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2012

Added on Sep 29 2009

8 comments

12,898 views