Slash Boxes
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

tinman (2063)

  (email not shown publicly)

tinman spent a few years mucking around industry before going back to school for a Masters. Currently not enjoying the weather in North England..

He wrote Perl that looked suspiciously like C code in 1998, while working as an intern, and has been trying to cure that bad habit ever since.

Journal of tinman (2063)

Thursday November 08, 2001
01:37 AM

refactoring and generally mucking around old code...

[ #1197 ]

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*) 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..

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.