1 Reply Latest reply on Jun 12, 2019 2:54 PM by Mahmoud_Rabie

    Invoke R scripts with data from .csv in application in Apex

    choracy69
    choracy69 Jun 12, 2019 10:11 AM

      Hi everyone,

       

      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.

       

      Any suggestions?