Help using Base SAS procedures

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

Reply
Contributor
Posts: 55

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

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?
Super Contributor
Super Contributor
Posts: 3,174

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

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
Ask a Question
Discussion stats
  • 1 reply
  • 82 views
  • 0 likes
  • 2 in conversation