Re: Question on automated reporting

On Fri, 29 Dec 2000 13:46:52 GMT, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

>Derek,
>
>1) You can still use your Perl scripts with DBI to connect to an Oracle
>database (through cron).
>2) You can write standard shell scripts to do the same thing (through
>cron).
>3) You can use DBMS_JOBS to automate jobs (much like cron).

Thanks, I'll check DBMS out.

>There is no one "right" way and no "wrong" way if you choose any of
>these options. They are just a little different. It all depends on what
>you are used to. Since you are already using Perl, why not use the same
>scripts?

The short answer is they suck.

The long answer is that because we were hooking up to a particularly difficult and kludgy database front-end, the Perl scripts I've inherited include home-grown modules to support the system particulars, and are ill-commented and designed to boot. As a result, running the scripts takes much more system resouces than it should, and I'd just as soon write good ones from scratch.

So I guess there's a seperate question, then, which is "is there a good resource for writing Perl for Oracle for someone who already knows SQL and Perl?"

Thanks for your help. Received on Tue Jan 02 2001 - 08:37:16 CST