CODEWITHSUNDEEP
plsqloracle11goracle-apex
massko
massko

Reputation: 589

APEX download files app for customer

I have theoretical question as I'm not familiar with Oracle APEX yet and I don't know if it's worth to start with my idea.

case:

Now, I want to create apex app where client could log in, see the list of files in shared folder (like in windows explorer or total commander maybe or just as a list that he can chose from), browse one of them and download to his local machine.

I've found lot of articles with solutions like uploading files into database as BLOB and then downloading it - that is not a solution I'm looking for.

Did anyone try to do it that way? Is it possible?

Upvotes: 0

Views: 1198

Answers (1)

Bahadirs
Bahadirs

Reputation: 188

there can be different options for it.

in apex web page report, you can give href hyperlinks to rows

if i would be you,i would modify my pl/sql procedure for recording the file names and location to a table while it is generating files.

then at apex app i would prepare my report for the table and give hyperlink to each file location. then at click of hyperlink browser would download that file (like coding a file link in html)

but in this scenario files should be in a network share or folder should be at a web server depending on your architecture and it will need appropriate access rights, after click browser will handle the file

Upvotes: 1

Related Questions