Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BLOB download file name

danteswariApr 7 2016 — edited Apr 7 2016

I have a table say Document with following attributes and data

| DOCUMENT_ID | NUMBER |
| TRACKER_ID | NUMBER |
| BLOB_COntent | BLOB |
| DESCRIPTION | VARCHAR2 |
| MIME | VARCHAR2 |
| FILENAME | VARCHAR2 |
| LAST_UPDATED | DATE |
| CHARACTER_SET | VARCHAR2 |

| Document
_ID | Tarcker_ID | Blob_content | Description | MIME | Filename | last updated | character_set |
| 62 | 122 | [datatype] | Test32 | text/plain | Test32.txt | - | - |
| 63 | 125 | [datatype] | Test32 | text/plain | Test32.txt | 04/07/2016 | |

when I try to download it from the report I see this

Capture.PNG

I want this download text to be the file name and when the file is downloaded on the system I want to file name to be the right name with right extension which is stored in columnn "Filename" for example text32.txt. How do I do that?

Capture.PNG

Thanks for your help..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2016
Added on Apr 7 2016
#apex-discussions
11 comments
1,503 views