Programming

So, I have a 'task' to create communication channel between Oracle db (11gR2 on AIX) and some client wich is choosed to be a .net client (.net framework 3.5).

we created a pipe on client (.net) side using:
System.IO.Pipes.NamedPipeClientStream pipeClient = new NamedPipeClientStream("127.0.0.1", "testpipe", PipeDirection.InOut, PipeOptions.None, TokenImpersonationLevel.Impersonation);

on a Oracle side, I created a dbms_pipe wich sends data using:
dbms_pipe.create_pipe
and
dbms_pipe.send_message

so,
sqlplus client manages to listen (to receive) messages from database when it sends a message, but I don't know how to make it with some client

In unix, pipes are files. So, unless your .net app actually creates a resident UNIX process it cannot even see the pipe (file) Oracle created. .net does not run on AIX natively.

You have to use tcp SOCK_STREAM sockets. Look into the UTL_TCP Oracle package.

This won't work. The named pipe facility in .NET is NOT the same as a DBMS_PIPE. They are not compatible, so you would have to have Oracle execute .NET code to pull data from the named pipe. Since this can't happen (easily), it's easier just to use the DBMS_PIPE and have the client use that.

So, if you create a package that can read/write to the DBMS_PIPE and connect your .NET client to the database and call that package then you should be good to go. See here for more information.