'Excel 365 How to run an Oracle Stored Procedure from Get Data

I am having a problem working out how to run an Oracle Stored Proc from Excel's:-

Get Data -> From Database -> From Oracle Database -> Advanced Options section.

I can connect ok to Oracle and query tables from within the Advanced Options, but when I try and execute the following stored proc, EXEC sp_Test or EXECUTE sp_Test

I get the following error message:-

Unable to connect

We encountered an error while trying to connect

Details: "Oracle: ORA-00900: invalid SQL statement"

This stored proc works fine from both within SQL Developer and from an SSRS report.

There are no parameters in the Stored Proc.

Any thoughts on how I can achieve this will be gratefully accepted.

Regards,

NJC



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source