Re: LOOping clobbering variable

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.