topic Re: Oracle stored procedure call from SAS in SAS Programming

Oracle stored procedure call from SAS

anirudhs — Mon, 02 Jan 2017 09:26:09 GMT

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

Re: Oracle stored procedure call from SAS

Kalind_Patel — Mon, 02 Jan 2017 09:28:52 GMT

You can call oracle stored process from SAS,

Here is the link for code:

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

Re: Oracle stored procedure call from SAS

anirudhs — Tue, 03 Jan 2017 05:59:10 GMT

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

Re: Oracle stored procedure call from SAS

Kalind_Patel — Tue, 03 Jan 2017 06:22:06 GMT

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.