Re: Piping data out of PL/SQL ?

In article <290gkt$76n_at_hsc.usc.edu> rpinder_at_hsc.usc.edu (Rich Pinder) writes:

   I'm trying to use the processing features of pl/sql code blocks, but    I want to output the results either to stdout or (more desirably) to    a Unix pipe. The examples in the manuals seem to show only DML    statements - the results of the if/else or while constructs are used    in update, insert or delete statements.

   I'd rather not create temporary tables to hold output, especially    when the end goal is to get data in either unix files, or piped to    formatting scripts and then out to the printer......

   Perhaps I'm missing something as I make the transition from another    RDBMS to Oracle.... I would sure like some ideas.

If you want to...

Write back to the client application (sqlplus, sqlforms, etc), please review the DBMS_OUTPUT package.

Pipe output to any client application (even on a different node), please review the DBMS_PIPE package.

Pipe output to multiple client applications, please review the DBMS_ALERT package.

Send an Oracle*Mail message,
please review the DBMS_MAIL package.

happy piping,

Magnus Lonnroth
Oracle Sweden

[My opinions are not supported] Received on Fri Oct 08 1993 - 00:59:38 CET