I am trying to retrieve the blob data along with other fields from database table & put it in a result set using a PL/SQL procedure.
Some how I could n't get the blob properly in the result set. I didn't want to get by a blob locator.

Is there anyway I can get the blob data in the result set through my PL/SQL procedure