I have Oracle Database with Oracle APEX on windows server. I am suing Oracle Apex 18.1
In this server I also have installed R.
I have simple application in apex and now my aim is: invoke r scripts from my apex application. Can anyone tell me how can I do this?
I have on this server in one location a csv file like: input_data.csv with source data to r script. In other location I have r script.
I want to create BUTTON like 'START CALCULATION' and it working like: invoke r scripts with data source from .csv file and return some data (results) and save it in oracle table.
(1) You could use MLE to call Python
Adding Python module to MLE which is used by APEX
(2) Then from Python you could call R script
I hope that helps