Sigh...find myself without any officially assigned work for the moment, so dug out an old Oracle schema dumping script, and decided to rewrite.. Ouch..but even code that was written a few months ago seems to be very longwinded and simplistic now.. not elegant at all, so this is the time to rewrite, I feel..
Its pretty Oracle specific, and uses the dictionary views to dump a complete description of the database in XML form, tables, views, sequences, materialized views, the whole nine yards... I just needed it to get all the stored procedures and packages out of the database in a compile ready form.. somehow it also mutated into a DB diff tool..
Why am I not using DDL::Oracle, I ask myself for only about the 100th time, mostly because this sorta seems cooler to me (buzzword warning: this dumps stuff in XML *grin*)..at least I know about DBI placeholders now, thanks to Perlmonks, and so I'm seeing a HUGE reduction in the number of prepare statements already...
Hopefully I can post it in PM.. haven't posted in ages, it seems..
