S
slacroixak
Guest
User Defined Functions are a bit like OO methods in the sense the signature is checked at compile time, as opposed to procedures that give bad surprises at runtime. Therefore, I tend to favour functions as much as possible in old .p's when one cannot move to OO for maintenance sake** As consequence, I don't mind dealing with a function with multiple output params, however I do not like to mix the return value and output params. Since a UDF cannot be defined as VOID, for the case of multiple output params, I would do the old trick of defining the UDF as LOGICAL, and not return anything. **one important difference between a UDF and a procedure : the later can natively hold a transaction whereas a UDF does not, but one can still define a transaction block explicitly in his UDF
Continue reading...
Continue reading...