I am using apex 4.0.2 version and Oracle 11g.
I am able to save e-signature pad (TOPAZ systems) signature string using HEXTORAW() and I am viewing the resulting signature image.
I am displaying it back in APEX in an item as Display Image.
Otherwise I am not able to extract this blob column using pl/sql query. It is giving me buffer too small error. I have a requirement to get this image from oracle table and display it in an RTF template using BI Publisher. Please help me if possible.