You can call Oracle stored procedures several ways using SAS/ACCESS Interface to Oracle. SAS/ACCESS Interface to Oracle cannot be used to obtain a result set from calling a stored procedure. Stored procedures can be called via the EXECUTE statement within the PROC SQL Pass-Through facility. However, this will only run non-query type statements. Therefore, result sets cannot be returned.

As a work around, another stored procedure can be created that will call the stored procedure in question and write the result set to an Oracle table. SAS can then access the table that was just created.

You can call stored procedures using the DBCONINIT and DBCONTERM LIBNAME access options when executing stored procedures that do not return a result set or output parameters. A stored procedure that might provide additional control over the interaction between your SAS/ACCESS interface and the dbms can be executed here during dbms connection/disconnection. For example:

You could also use explicit SQL using PROC SQL PASS-Through using the EXECUTE statement to call a stored procedure that does not return a result set or output parameters. FOr example:

Operating System and Release Information