CODEWITHSUNDEEP
oracle-apex
Coding Duchess
Coding Duchess

Reputation: 6899

Using images on Oracle APEX pages

I have a page in APEX that uses many external images. I loaded all of the images for that page into a separate folder in Static Application Files under Shared Components and I am just referencing those on the page. I am not sure I like it as it looks messy when you open Static Application Files. It was suggested to me to load the images onto the SharePoint and access them using URL from APEX but that also does not seem like a good solution - URLs are very long and make the code messy. Another option would be to host them on application server. I am trying to figure out the best way and would love to hear some suggestions. Thank you in advance for your valuable input

Upvotes: 2

Views: 578

Answers (4)

Philipp
Philipp

Reputation: 745

We had a similar problem as we had a feature where users had to upload images and went with loading the images into the DB at first.

In order to retrieve them we used the APEX REST service and it worked fine enough.

Once we also had to store videos though and had to make them available on mobile as well,we went with a shared network storage and just put the file names into the database.

Either of these options should reduce "messiness" and work fine.

Upvotes: 0

GasparYYC
GasparYYC

Reputation: 188

You can read the file names list them in the application and when the users "selects" you can load the file by loading a BLOB in the database. In my case I do that by invoking a custom OS Job that lets me do that.

Upvotes: 0

Tony Andrews
Tony Andrews

Reputation: 132570

If the "messiness" of the list in Static Application Files concerns you, you could save some report filters:

  1. Report "Folder XXX images":

File Name like 'xxx/%'

  1. Report "Other files":

File Name not like 'xxx/%'

Upvotes: 1

Littlefoot
Littlefoot

Reputation: 142720

Another option is to store them into BLOB columns in a table within the database.

  • Pro:
    • they are backed up along with the rest of your data
    • Apex is happy when displaying such data (I mean, it is a simple task to do that, whether you're displaying them in an interactive report, classic report, form ...).
  • Contra:
    • database size grows

Upvotes: 2

Related Questions