https://communities.sas.com/t5/Decisioning/Can-SID-5-6-invoke-a-Stored-Procedure-in-an-Oracle-database/m-p/874577#M67 <P>You can definitely do this with Base SAS and SAS /ACCESS to Oracle with the SQL Passthrough EXECUTE statement. Since this is a specialist product it might be better to ask Tech Support.</P> Mon, 08 May 2023 22:51:38 GMT SASKiwi 2023-05-08T22:51:38Z https://communities.sas.com/t5/Decisioning/Can-SID-5-6-invoke-a-Stored-Procedure-in-an-Oracle-database/m-p/874459#M66 <P>Hi experts,</P> <P>&nbsp;</P> <P>It seems from the SID 5.6 <A href="https://go.documentation.sas.com/doc/en/edmcdc/5.6/edmug/p0zqdi1bacsmexn1va2096e6i5or.htm" target="_self">doc</A> that the Data Query node does not support/allow to invoke an Oracle Stored Procedure as it allows only the <SPAN>SELECT, INSERT, UPDATE, and DELETE statements</SPAN>. Can someone confirm my understanding is correct? If it is correct then what options do I have? I assume I can write custom Python code but are there more options?</P> <P>&nbsp;</P> <P>Thanks</P> Mon, 08 May 2023 14:25:02 GMT https://communities.sas.com/t5/Decisioning/Can-SID-5-6-invoke-a-Stored-Procedure-in-an-Oracle-database/m-p/874459#M66 EyalGonen 2023-05-08T14:25:02Z https://communities.sas.com/t5/Decisioning/Can-SID-5-6-invoke-a-Stored-Procedure-in-an-Oracle-database/m-p/874577#M67 <P>You can definitely do this with Base SAS and SAS /ACCESS to Oracle with the SQL Passthrough EXECUTE statement. Since this is a specialist product it might be better to ask Tech Support.</P> Mon, 08 May 2023 22:51:38 GMT https://communities.sas.com/t5/Decisioning/Can-SID-5-6-invoke-a-Stored-Procedure-in-an-Oracle-database/m-p/874577#M67 SASKiwi 2023-05-08T22:51:38Z