Call an Oracle stored proc from SAS

Asked By jeremiah mai 60 points N/A Posted on - 04/07/2012

Hi everyone

Iam using SAS 9.0. I would like to pass values and return values before that I want to know, How to call an Oracle stored Proc from SAS?

Thanks

• Status: Open
• Question Views: 3491
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: SAS

Answered By Brian Tnny 0 points N/A #110239

Call an Oracle stored proc from SAS

 

 

 

There many ways to call Oracle stored procedures using SAS/ACCESS Interface to Oracle. Basically, SAS/ACCESS Interface to Oracle cannot used to acquire a result set from calling a stored process. This stored measures can called via the “EXECUTE” statement within the “PROC SQL” pass through ability.

 

You can call stored procedures using the “DBCONINIT” and “DBCONTERM LIBNAME” entrée options.

You could try use explicit SQL using PROC SQL pass through using the “EXECUTE” statement to call a stored procedure. They are not revisit a result set or output parameters.

I think this should work:

Just try it,

 

proc sql;

   connect to oracle (user=userid password=password path=database_name);

   execute (execute st_pr_name('parm')) by oracle;

   disconnect from oracle;

quit;

 

I hope it will be work properly.

 

 

 

About Brian Tnny

Questions
0

Answers
57

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 06/24/2012
• Question Category: SAS