0

I am trying to put a php file on a folder and call it using UTL_HTTP.REQUEST from SQL and in APEX. I used xampp software to host it and it works. So I was wondering if there is a way to put in a file "somewhere" in ORDS or Database directory so I could access it in the same way? Or is there any way to access a file from URL like "localhost:8080/ords/[my folder and file name]"

My Config:

Database 19c

APEX 22.1

ORDS 21.4

Koen Lostrie
  • 14,938
  • 2
  • 13
  • 19
Adnan
  • 5
  • 1
  • 4

1 Answers1

0

You can configure basic file access by configuring a document root, but this is file access not Web CGI style components like PHP, Pything, Perl etc etc.

If it is just file access you control that via the standalone.properties file

standalone.doc.root=/u01/files/standalone/doc_root
Connor McDonald
  • 10,418
  • 1
  • 11
  • 16
  • The php file I have contains an API call which retrieves data from a HTTP (not HTTPS) website. As UTL_HTTP requires the SSL certificate validation, we had to bypass it by that php file (which I am not very familiar with so forgive me for my amateur take on this). I was wondering whether I could do something like that on my local machine with standalone ORDS. – Adnan Aug 09 '22 at 12:13
  • Nope. You'd need to use (say) Tomcat for that. Tim has a nice installation guide for ORDS on Tomcat https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat-22-onward – Connor McDonald Aug 09 '22 at 23:18