We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Attachment download from table in vbcs

Received Response
21
Views
3
Comments
edited Dec 1, 2021 11:49AM in Visual Builder 3 comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!