I have created a Stored Procedure using the Project creation approach. While creating the stored procedure using .procedure file, i could not define "WITH RESULT VIEW" property for the procedure. This procedure has one input parameter of type DATE and one output parameter of type "Local Table Type".
Now i want to call this procedure from my SQL Script Calculation View. I am not able to call using SELECT statement as the procedure is not defined with result view and CALL statement is expecting me to pass a variable of table type to the out parameter.
I have tried using null and ? for out parameter. I mean i used call statement like CALL <PROCEDURE> (TO_DATE('2014-02-17', 'YYYY-MM-DD'), null), as well. This works in SQL console but not in calculation view.
Any pointer on how can i call the stored procedure from my calculation view would be of great help.
Thanks & Regards,