Re: Oracle Question

Bhushan wrote:
> Actually my requirement is -
> I want a Unix Program which when sees the record, it will
> automatically load it
> to an Oracle table(i can write script for this but i want program to
> accpet this record ) this program should listen on specific port , and
> it will always run on Unix. this record will be sent by another
> program which i have.

I don't see the problem - nor any requirement for Oracle pipes or advance queues.

E.g., you write a Pro*C program. It listens on a TCP (or UDP) socket for data. When data arives it uses an SQL INSERT statement (or preferable a PL/SQL Stored Procedure) to insert that data into Oracle.

Same can be done with Perl using Perl-DBI for Oracle.. coded in a matter of minutes.

Remember that a file handle is a file handle is a file handle.. and that is exactly what a socket handle essentially is. A file handle. You read data from it using -standard- I/O calls. You write that data into Oracle using -standard- SQL. That simple.

--
Billy