Oracle 7.3 - TCP/IP Sockets 
Author Message
 Oracle 7.3 - TCP/IP Sockets
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




Mon, 12 Mar 2001 03:00:00 GMT
 Oracle 7.3 - TCP/IP Sockets

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.

Quote:

>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





Fri, 16 Mar 2001 03:00:00 GMT
 Oracle 7.3 - TCP/IP Sockets
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:

Quote:
> 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.


> >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





Fri, 16 Mar 2001 03:00:00 GMT
 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.

Quote:

>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.


>> >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





Fri, 16 Mar 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Comparing NetBios->TCP/IP vs TCP/IP Sockets running SQL Server ODBC

2. TCP/IP Sockets, UNIX Sockets

3. Performance: Unix sockets vs. TCP/IP sockets

4. Oracle 7.3 server + W95 + TCP/IP = Dial UP ???

5. TCP/IP Problems - IDS 7.3 & SuSE Linux

6. ..[Named Pipes]Specified SQL server not found or ..][TCP/IP Sockets]General network error

7. Help - Conncetion Error ][TCP/IP Sockets]Connection Read[recv(0)]

8. TCP/IP Socket configuration

9. Question on MS SQL TCP/IP Sockets

10. [ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or

11. TCP/IP socket connection slow?

12. ISAPI cause [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()) error


 
Powered by phpBB® Forum Software