The attached code is part of a stored procedure, which is where I'm getting the eeror. Max cursors is set at 1024 and I just can't see how I'm going anywhere near that. thanks for your help.