Re: communication between PL/SQL and OS scripting languages

Dino Hsu <dino1.nospam_at_ms1.hinet.net> wrote in news:1e2oqtkueqb36igg3bullnibu398s3tpov_at_4ax.com:

> Dear all,
>
> In writing ETL (extract, transform, load) programs, we generally will
> use both PL/SQL and OS scripting languages, either the former calling
> the latter, or the latter calling the former. Sometimes, the caller
> does need to know about the result of the callee excution. I am
> interested in knowing any better ways than via a flat file, which
> requires efforts of parsing or interpretation, especially in the case
> of passing structured data. Speaking of scheduling, do you prefer
> shceduling with Oracle DBMS_JOB or the OS scheduler? Practical advices
> are much appreciated.
>
> Dino
>
>

I prefer Perl & cron.

YMMV Received on Sat Sep 22 2001 - 12:13:58 CDT