SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Passing Multiple Parameters to Oracle Stored Procedure through SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

Passing Multiple Parameters to Oracle Stored Procedure through SAS

Hello Folks,

 

I want to pass Multiple parameters(say like 3, one of them should be a null value) to a Procedure that is stored in Oracle. I want to run this procedure through SAS 9.3.

 

I can pass single parameter using the below method

 

proc sql;

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

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

disconnect from oracle;

quit;

 

However, i can't run the procedure with Multiple input Parameters. Can someone help me out with an example ?

 

Thanks,

Pavan


Accepted Solutions
Solution
2 hours ago
Super User
Posts: 3,853

Re: Passing Multiple Parameters to Oracle Stored Procedure through SAS

This isn't a SAS issue it is an Oracle syntax issue. A quick Google search suggests you use multiple parameters like this:

 

proc sql;
connect to oracle (user=userid password=password path=database_name);
execute (execute st_pr_name(parm1, parm2, parm3)) by oracle;
disconnect from oracle;
quit;

 

 

View solution in original post


All Replies
Solution
2 hours ago
Super User
Posts: 3,853

Re: Passing Multiple Parameters to Oracle Stored Procedure through SAS

This isn't a SAS issue it is an Oracle syntax issue. A quick Google search suggests you use multiple parameters like this:

 

proc sql;
connect to oracle (user=userid password=password path=database_name);
execute (execute st_pr_name(parm1, parm2, parm3)) by oracle;
disconnect from oracle;
quit;

 

 

Occasional Contributor
Posts: 19

Re: Passing Multiple Parameters to Oracle Stored Procedure through SAS

thank you so much SASKiwi, it worked very well
☑ This topic is solved.

Need further help from the community? Please ask a new question.

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