Skip to Content
0
Former Member
Feb 17, 2015 at 12:38 PM

Call Stored Procedure in SQL Script Calculation View

380 Views

Hi All,

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,

Vishwa