Here is an odd but effective and efficient way of doing it

SELECT A.*, SP.SP_RESULT FROM TABLE_A A
JOIN MY_SP(A.INPUT_PARAM_1,A.INPUT_PARAM_2,etc) SP
ON 1 = 1

It's not documented, but it works.

Roger Vellacott