Re: Oracle 7.3 - TCP/IP Sockets

Hmm...

I'm still not entirely sure *what* you are actually trying to achieve?...

1. If you need to communicate between two Oracle databases on servers that are connected by TCP (to exchange data, for instance), then forget the TCP/IP low-level bits. Oracle SQL*Net (once configured correctly) will do everthing for you. Look at database links, and choose your tool (sqlplus, etc.).
2. If you need to communicate between two systems exchanging data that has nothing to do with Oracle whatsoever - which is what you seem to be implying - then don't use PL/SQL. Use C/C++/Perl/Java, etc. to do it.

MotoX.

Detlev Goebel wrote in message <360F569F.F01B3042_at_www.gzs.de>...
>Hallo,
>
>the reason is:
>
>we like to purchase a software which is complete written in PL/SQL. The
company
>told me, that it is
>more comfortable for them whether they can write a routine in PL/SQL than
in C.
>
>Now I'm investigate for solutions.
>Of course, for me a C-Program is the best solution.
>
>Detlev
>
>
>MotoX schrieb:
>
>> Er, why? You can use TCP/IP (via C, C++, Perl, Java, etc.) to connect the
>> machines, provided they've got TCP/IP stacks installed and configured,
and
>> they can find a route to each other. So where did SQL or PL/SQL come into
>> this? Please state *what* you are trying to achieve.
>>
>> In the meantime, look at 'pipes' (Ora 7 & 8) and external procedures (Ora
8
>> only). Maybe they will help you with what you are trying to do.
>>
>> MotoX.
>>
>> Detlev Goebel wrote in message <360A5FFA.6EDA1127_at_www.gzs.de>...
>> >Hello,
>> >
>> >I'm going to buid a system where two different machines must talk
>> >together.
>> >My question is :
>> >
>> >Is it possible to access TCP/IP Sockets directly from SQL or PL ?
>> >
>> >
>> >Thanks in advance
>> >
>> >Detlev
>> >
>> >mailto:goebel_at_www.gzs.de
>> >
>> >
>
>
>
Received on Mon Sep 28 1998 - 10:56:51 CDT