PROC SQL: Need syntax for executing Oracle PL/SQL Stored Procedures

JMarkW — Fri, 31 Oct 2008 11:55:49 GMT

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?

Re: PROC SQL: Need syntax for executing Oracle PL/SQL Stored Procedures

sbb — Fri, 31 Oct 2008 12:36:42 GMT

Suggest searching the SAS support website http://support.sas.com/ using your keyword references. Here is one of several hits found.

Scott Barry
SBBWorks, Inc.

Usage Note 18350: Calling Stored Procedures using SAS/ACCESS Interface to Oracle
http://support.sas.com/kb/18/350.html

topic PROC SQL: Need syntax for executing Oracle PL/SQL Stored Procedures in SAS Procedures

PROC SQL: Need syntax for executing Oracle PL/SQL Stored Procedures

Re: PROC SQL: Need syntax for executing Oracle PL/SQL Stored Procedures