> Jared, > > I have not thoroughly tested this, but the basic premise does work and = > is > valid. Create an external table that's defined on a named pipe, rather > than a file. I was half expecting an ORA-600 ora ORA-7445, but Oracle=20 > (9.2.0.5 on Solaris 8) seems ok with it. I just did basic testing. > > select * from my_pipe; > will immediately return any data in the pipe, or block waiting on data. > If you send multiple lines of output to the pipe, all the lines will=20 > be outputted in Oracle. Very cool Mark, hadn't thought of that one. Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------