Re: How Can Oracle Get Com Port Message?

Thenard,

You need to create a program in a lower level language, eg C.

In our case we had to load data via the client's Com port into the database, with transfer initiated from an Oracle Form. A design decision was made to use a two-phase operation. First a Windows .DLL runs on the Client, reading data from the Com port and creating a text file.
The ORA_FFI (Foreign Function Interface) package provides the means to access DLL functions from within a Form. Subsequently the Form read the text file, using TEXT_IO procedures, and updated the database.
I'm told that Oracle provides a demo form with Developer/2000 called FFI_GEN. Hope this gives you some idea of what's required.

ªü´ö Thenardier <Thenardier_at_POBoxes.com> wrote in article <34617e2c.988753_at_news.netvigator.com>...
>
> Hello all,
>
> My system needs to capture data from the com port (com1 or 2)
> that receives data transfered from a turnstile type of machine.
> But so far, it seems Orcale does not support such low level
> data communication technology in its development tools.
>
> How can i deal with such situation? Thanx a lots!
>
>
> Thenard
>
Received on Mon Nov 03 1997 - 00:00:00 CST