 Re: How to convert a stored-proc with one result-set into a table udf
You can't
declare handlers,
declare session tables,
issue ASSOCIATE LOCATORS (ALLOCATE CURSOR),
issue FETCH
in SQL funcions.
That is the reason to use external UDF.
Sincerely,
Mark B.
|