'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 |
---|