Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Attachment download from table in vbcs — Cloud Customer Connect
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
32
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!