Running Oracle Procedures using SAS DI

[jmehul]

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;

[JosvanderVelden]

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

[jmehul]

@JosvanderVelden 

I have followed the same link.

Still facing an issue.

[JosvanderVelden]

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