BookmarkSubscribeRSS Feed
Rahul_B
Obsidian | Level 7

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;

2 REPLIES 2
LinusH
Tourmaline | Level 20

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.
Data never sleeps
Rahul_B
Obsidian | Level 7

Thanks That helps ! 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1389 views
  • 0 likes
  • 2 in conversation