DATA Step, Macro, Functions and more

Oracle stored procedure call from SAS

Reply
Occasional Contributor
Posts: 13

Oracle stored procedure call from SAS

how to import the oracle stored procedure using the odbc connection in sas.

where we can pass the parameter's to the stored procedure.

i need the basic code connecton for the procedure

Frequent Contributor
Posts: 96

Re: Oracle stored procedure call from SAS

You can call oracle stored process from SAS,

Here is the link for code:

http://support.sas.com/kb/18/350.html

Occasional Contributor
Posts: 13

Re: Oracle stored procedure call from SAS

I am searching for the connection using the odbc for oracle process to import 

Frequent Contributor
Posts: 96

Re: Oracle stored procedure call from SAS

Okay, than try this code

 

proc sql;
connect to odbc as oracledb
(datasrc="yourDSN" user=xxxx password=xxxx);

create table work.test_dataset as
select *
from connection to oracledb
(
execute schema.oracleStoredProcedure
@Param1 = 'value1',
@Param2 = 'value2',
@Param3 = 333;
);
quit;

Please note that you need  SAS/Access to ODBC or SAS/Access to Oracle license to execute oracle stored process.

Ask a Question
Discussion stats
  • 3 replies
  • 165 views
  • 0 likes
  • 2 in conversation