On Sat, 1 Jan 2005, K Anderson wrote:
> The enclosed function returns a proper result only when the LOOP and its
> enclosed functionality is removed from the function. Notice near the
> return I have xml=xml||'</transaction>';
>
> That should at the least return what ever is in xml with </transaction>
> concatinated, or so I would hope. But it's empty.
Is it possible that you're ending up with a NULL after the loop? NULL
concatenated with anything is still NULL. If any of the various fields
you're concatenating in could be NULL you'll need to guard against that.