you could use UTL_TCP on the oracle side to send TCP/IP communications.

----- Original Message -----
From: "grea" <mssqldba-ezmlmshield-x45159894.[Email address protected]
To: "LazyDBA.com Discussion" <[Email address protected]
Sent: Thursday, May 27, 2004 9:38 AM
Subject: HL7 message import


> Hi folks,
> I've got a MSSQL DB that I want to receive updates from an Oracle DB via
> TCP/IP Messaging (HL7). Anyone know how to get these messages in? Do I
need
> 3rd party SW to listen for them?
> Regards
> Gab
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> NCHT
> **********************************************************************
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>

MS Sql Server LazyDBA home page