2 Replies Latest reply: Dec 5, 2013 4:29 AM by user8966924 RSS

    Unable to download a blob file

    user8966924

      Hello All,

       

      I have created an application which requires uploading and downloading of the files.

      I have created a column in my table 'files' as BLOB type.

      I am able to upload the file into the DB and it gets saved.

      Now, I have created an interactive report to download the file file

      I followed the following site

      http://awads.net/wp/2012/03/12/how-to-download-blob-content-as-a-file-using-oracle-application-express/

      But it is throwing following error:

       

      ORA-06502: PL/SQL: numeric or value error: character to number conversion error


      One thing that I have observed is that eventhough my column is blob type, in the Report Attributes it shows Column Type as 'Others'


      Kindly help me resolve this.