Guys,
In the past when writing ETL processes for data warehouses I did a lot with scripting on Unix and used SQL for some basic processing. I have been moving more into creating stored procedures and also separately been working on modularizing and making generic code. To me with native dynamic sql, utl_smtp and other Oracle packages/procs available it is cleaner and easier to modularize these codes into different stored procedures. Thereby I am moving a lot of the code I used to run into stored procs at the same time I am modularizing/generi. it. Eventually the script will be doing some basic things. Does anyone have an opinion on the approach I am taking as to its long-term viability/maintainability/reusability? I would love any and all opinions.
Thanks,
Paula
