Oracle stored procedure call from SAS

[anirudhs]

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

[Kalind_Patel]

You can call oracle stored process from SAS,

Here is the link for code:

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

[anirudhs]

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

[Kalind_Patel]

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.