Re: How to write data to OS pipe using PL/SQL

Assuming that you are using Oracle8 or higher, You can call your C routine by creating a PL/SQL wrapper using an "AS EXTERNAL"
clause.

In 8i you can create a PL/SQL Java wrapper.

You might want to consider writing your ftp-deamon in Java and then you can use all the wonderful Java networking classes.

If you can get ahold of the book "Oracle8i Advanced PL/SQL Programming" I think you will find all the information you want in Chapter 10: "External Routines".

Mike

Szymon <smanduk_at_profidata.com.pl> wrote in message news:98tjq7$p2$1_at_news.tpi.pl...
> Hello!
>
> How to write data into an OS pipe from PL/SQL procedure?
>
> I have to write C programme acting similar to ftp-deamon.
> Programme waits for data to be placed in pipe by PL/SQL routine,
> then sends the data futher to a non-Oracle RDBMS.
>
> I'm looking for possible solutions.
>
> I found dbms_pipe package which implements, as far as I understood its
> description,
> communication of messages between database sessions based on internal to
> Oracle memory
> structures. So I think this is not what I'm looking for.
>
> Any ideas, comments, suggestions?
>
> BTW, communication is bidirectional so I have to write another programme,
> which will place recieved data into Oracle database.
> But I think this can be done using Pro*C/C++ precompiler.
>
> TIA
>
> Simon
>
> P.S. I'm not an expert in Oracle technology so please be understanding if
> the question is vague.
>
>
>
Received on Sat Mar 17 2001 - 18:24:28 CET