APEX 22.2.4
I have a site where random images are displayed and the trick is I need a way to store the image URL in a table. I started going down the path of using PL/SQL and UTL_HTTP, until I ran into ACL issues. Not wanting to mess with ACL, I started investigating options for just assigning the src to img tags, knowing the resulting image would be redirected to a static URL. I can't find a way to get the redirected URL from APEX and it's not possible via Javascript. Yes, I'm a noob at APEX, so are there any cool tricks I can use to add middleware and get the redirected img source? Or should I hack away at UTL_HTTP again and figure out the whole ACL bit?