Yep, I don't have any problems executing Oracle stored procedures in
pass-through.  Another possibility depending on the task is a view that
might be able to contain all of your code in one view [that's accessible by
both pass-through and libname SQL].

-Joe

On Tue, Jan 5, 2010 at 1:39 PM, Mary <mlhoward@avalon.net> wrote:

> Has anyone ever executed an Oracle Stored Procedures from Pass-through SAS
> SQL?  I'm pretty sure this would work, but wanted to ask if there were any
> problems with this before asking our database group to setup a stored
> procedure on a task we do often that we'd like to execute from SAS since we
> always have SAS programs to run on either side of it.
>
> A stored procedure in Oracle would be the same as a PL/SQL block
>
> -Mary
>