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
You can call oracle stored process from SAS,
Here is the link for code:
I am searching for the connection using the odbc for oracle process to import
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.