Hi there
Is it possible to execute a PL/SQL Oracle package on the Database via SAS DI Studio?
I know it is possible to execute functions in this manner, however haven't come across an actual PL/SQL package been executed in this manner.
If it is possible, would anyone have examples/reference doc's or code snippets to help me achieve this please.
A basic call of the package is below;
execute package.go();
Thank you
Aidan
I normally split such questions into two parts:
1. How can I do it with SAS
2. Can I use an existing DIS transformation or do I need user written code or a user written transformation
For 1: Yes, via explicit pass-through SQL. Here an example: https://renenyffenegger.ch/notes/Companies-Products/SAS/programming/proc/sql/oracle/call-function
For 2: That will depend on the details of your task but the SQL transformations like Execute will already allow for quite a few things. Just make sure to enable explicit pass-through so that you can use DB SQL syntax in the expression tab.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.