Can I call a procedure from a SQL Script calculation view

[#1]

Hi folks,

Is it possible to have a procedure in a SQL Script calculation view that calls other procedures, does some calculations, and then returns the values in the view output?

ie:

Call procedure 1 and get result

Call procedure 2 and get result

Then add the two results together and output?

I know I can create a CE_JOIN and I have experimented with various CE calculations but my question is whether it's possible to call other external procedures and return results in the view output?

Thanks,

-Patrick

[Ravi_Channe]

Hi Patrick,

So far, I could successfully execute a procedure and could get the result from the result view to another table variable and could use it in CE function.

Unfortunately I haven't been able to use the OUT parameter value yet. Will have to look into the code for details.

I am not very positive about the performance impact of this, as the CE operators and the SQL code in procedure are executed by different engines and there could be high data transfer between the engines which would deteriorate the performance.

Regards,

Ravi

[patrickbachmann]

Thanks for your feedback guys.  I will hopefully tinker some more with this today and update this with my findings in the next day.