Re: Export and Import Utility

Anytime I've done something like that I've always used temp tables to import the data. Putting them into the base tables seems like a bad idea: what if 2 users import the same data into the base table at the same time? What happens to unique indexes/constraints/etc? Importing into temps lets the users play around without damaging the base tables. The proc can then delete the data at the end of the ad-hoc situation (or when the user says to). To prevent collisions in the temps, you can use some unique id, like the userid, to make each set unique, so if 2 users import the same data, it's always distinct from other sets.

-- 
Steve Edelstein                      VOICE: 212-956-3670
Relational Business Systems          CompuServe: 74160,645
124 West 60th Street  Suite 47C            Author of
New York, NY 10023                    "Learning Oracle Forms"