IF @rtn = 0 
begin
  do something
  if @rtn = 0
  begin
    do something more
  end
  else
  begin
    flag error
  end
end
else
begin
  flag error
end

quote:

---

Thanks for your comments - some answers: -

I used goto labels because my original solution required the logging of a specific error message and then a general one e.g. 'Load of <file> failed at <Datatime>' so I used the goto label to keep all logging in the same place.
I think the double space formatting is my fault!
With regard to the speed of load, I have found the data pump task to be extremely efficient when loading files with a large number of records, although I havn't got any comparison figures with other methods.


Regards,
Andy Jones

---

You can still keep the error logging in one place. In my example where I've said flag error this could set an error flag and/or build an error message. Then at the end of the proc you'd just check to see if an error occurred and then log it.

I had a bad experience with goto's as a child and have been mortally afraid of them ever since


Thanks
Phill Carter

Edited by - phillcart on 10/31/2002 4:11:12 PM