topic Re: Run Oracle Stored Process in SAS Viya in Developers

Run Oracle Stored Process in SAS Viya

Rahul_B — Mon, 21 Jan 2019 12:00:27 GMT

Is it possible to run Oracle stored process in SAS Viya using proc fedsql or any other means?

similar to the below example in SAS 9.4

proc sql;

connect to oracle (user=userid password=password path=database_name);

execute (execute st_pr_name('parm')) by oracle;

disconnect from oracle;

quit;

Re: Run Oracle Stored Process in SAS Viya

LinusH — Mon, 21 Jan 2019 12:33:06 GMT

Given the documentation, I would say, depends...:

"The FedSQL functionality for CAS is a subset of the FedSQL capabilities that are available in SAS 9.4. The following FedSQL statements are supported in CAS:

CREATE TABLE, with the AS query expression
SELECT
DROP TABLE"

So it comes down to your requirement, if you need to execute this from a CAS session, or a workspace session.

Re: Run Oracle Stored Process in SAS Viya

Rahul_B — Fri, 08 Feb 2019 13:54:06 GMT

Thanks That helps !