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