topic Re: Running Oracle Procedures using SAS DI in New SAS User

Running Oracle Procedures using SAS DI

jmehul — Fri, 06 Sep 2019 13:49:56 GMT

Hi All,

We have created a code in SAS DI using user code transformation but we are unable to trigger the procedure in oracle
We have a stored procedure named AA_TEST_PROC_DI in oracle. Below is the code.

Pls, suggest us the right path.

proc sql;
   connect to oracle (user=xxx password="{SAS002}xxx" path=xxx);
   execute (execute xxx.AA_TEST_PROC_DI) by oracle;
   disconnect from oracle;
quit;

quit;

Re: Running Oracle Procedures using SAS DI

JosvanderVelden — Fri, 06 Sep 2019 14:47:52 GMT

Here is an example: https://support.sas.com/kb/18/350.html

Re: Running Oracle Procedures using SAS DI

jmehul — Mon, 09 Sep 2019 04:59:59 GMT

@JosvanderVelden

I have followed the same link.

Still facing an issue.

Re: Running Oracle Procedures using SAS DI

JosvanderVelden — Mon, 09 Sep 2019 11:03:53 GMT

If the documentation does not help I suggest contacting technical support: https://support.sas.com/en/technical-support/contact-sas.html.