Re: How Can Oracle Get Com Port Message?
Date: 1997/11/03
Message-ID: <01bce818$06d961a0$d33c1286_at_itwol-pc3963.itwol.bhp.com.au>#1/1
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 CET