Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

choracy69Jun 12 2019 — edited Jun 12 2019

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?

Comments

EJP
From what I understand, JAAS uses UDP (correct me if I am wrong)
You are wrong. JAAS doesn't use UDP. It doesn't do any networking at all. It is an API framework.
but that does not work for me because of some unique requirements
So you now need to review that decision.
978809
Thanks for the reply

When I run this code

loginCtx = new LoginContext( "Client",
new LoginCallbackHandler( username, password));

which uses this package import javax.security.auth.login.LoginContext;

It starts connecting to kerberos and I see it mentioning UDP ports in the console, I thought this was part of JAAS but it seems I was mistaken, that is not a problem now
So the question now is, is there a way to get SOAP in between the client and the kerberos without sending the username and password?
EJP
You need to do some basic reading about JAAS. Your question is too large to be answered here.
1 - 3

Post Details

Added on Jun 12 2019
1 comment
84 views