when any must be the last command in the stored proc

CREATE PROCEDURE ....

BEGIN
FOR SELECT...
DO BEGIN

END

when any do begin
end
END


if you need to catch the exception inside the FOR SELECT, i would create another stored proc to do the job, and call it inside the for select.

Jesus

>
>
>
>
>
> [Non-text portions of this message have been removed]
>