I'm looking details on how to utilize Oracle Stored Procedures using SAS. The only info I've found so far is:
---------------------------------------------
PROC SQL
;
CONNECT TO DBMS-NAME <( )>;
DISCONNECT FROM DBMS-NAME | ALIAS;
EXECUTE (DBMS-SPECIFIC-SQL-STATEMENT) BY DBMS-NAME | ALIAS;
SELECT COLUMN-LIST FROM CONNECTION TO DBMS-NAME | ALIAS (DBMS-QUERY)
EXAMPLE
proc sql;
connect to oracle (user= &user password= &PWD path= &PATH ) ;
exec(alter table official_index disable constraint FK1_INDEX_SID) by oracle;
exec(truncate table official_index) by oracle;
exec (alter table official_index enable constraint FK1_INDEX_SID) by oracle;
disconnect from oracle ;
quit;
Note that when you want to execute a stored procedure you need to specify
Exec (exec stored_procedure) by oracle;
--------------------------------------------
Does anybody know of a good manual or other resource?