View Single Post

   
  #8 (permalink)  
Old 02-27-2008, 07:18 AM
JohnO
 
Posts: n/a
Default Re: How to convert a stored-proc with one result-set into a table udf


4.spam@mail.ru wrote:
> 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.


But you can use those features in SQL procedures, right? If so, could
you call such a procedure from within a SQL function?

Regards
JohnO

Reply With Quote