Attachment download from table in vbcs

Summary:

Content (required):

Hi Everyone,

I have an requirement for upload and download the documents. I did upload document process.

When am going to download, I didn't get proper file content that downloaded document. I am using blob column for storing upload document content

Please find the below query for insert:

insert Into XXGRC_FILE_ATTACHMENT_TBL(ATTACHMENTNO,FILENAME,FILETYPE,FILESIZE,NEW_REQ_FILECONTENT,USER_ID,

        GROUP_REQ_ID,CREATION_DATE,CREATED_BY,LAST_UPDATED_DATE,LAST_UPDATED_BY)

values(XXGC_ATTACHMENT_SEQ.nextval,:P_FILENAME,:P_FILETYPE,:P_FILESIZE,rawtohex(:P_NEW_REQ_FILECONTENT),

        :P_USER_ID,:P_GROUP_REQ_ID,SYSDATE,:P_CREATED_BY,SYSDATE,:P_LAST_UPDATED_BY)