Re: alternatives to dbms_output?

On Fri, 15 Dec 2000 gregory.t.norris_at_mail.sprint.com wrote:

> Are there any alternatives to dbms_output for displaying text from a
> PL/SQL block? I've put together a little script which uses dynamic SQL
> to rebuild indexes into a different tablespace, and I'd like to provide
...

One method is too send your output to a pipe, and use a separate external process to read it.

There's an example at www.teleport.com/jkstill/util that uses Perl, and required DBD::Oracle.

This could easily be done in C or Java as well.

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_teleport.com
jared_still_at_enron.net Received on Sun Dec 17 2000 - 21:52:04 CST