Blobs returned from Execute Procedure

[ThanatosZA]

I have a strange issue when executing a procedure vs selecting from it.
If I select from it it returns my Blob as text, however if I use execute procedure then it returns the blob as a function instead.

As a side to this, when I use Execute procedure the result is returned as an Object only, but when you use select from Procedure, then the Result is returned as an Array with an Object in it.