I'm using the Export SQL to Excel smart service trying to call a stored procedure in an oracle database.Per the documentation, "{call My_SP(,,?)}" would mean that you have an SP with 3 parameters - 2 INs and 1 OUT representing the sysref cursor.When I attempt to make my call to a procedure with no inputs and only an output recordset as follows: ="{call TESTING(?)}"
The result is the following error message: "The following error was raised by the Export to Excel function: Missing IN or OUT parameter at index:: 1"
As a note, the smart service works when I call it with a SQL statement instead of the procedure call so everything else seems to be initialized correctly.
Any help is appreciated. Thanks!
Discussion posts and replies are publicly visible