Re: How to access a COM PORT from PL/SQL
Date: 7 Oct 2002 12:45:53 -0700
Message-ID: <92eeeff0.0210071145.316660b6_at_posting.google.com>
"Robert Bralic" <robert.bralic_at_si.tel.hr> wrote in message news:<ankrkn$dgfu$1_at_as201.hinet.hr>...
> I have one problem to solve and that problem
> is directly connected with reading something
> from COM port with PL/SQL.
> If you know how to access and send something and read
> something from COM port with PL/SQL
> plese e-mail me.
>
>
> Thanks in advance !
> Robert Bralic
> robert.bralic_at_si.tel.hr
I don't think you can from pure PL/SQL.
Either use some external procedure or use Java.
Check Java Communication 2.0 API (javax.comm) documentation at http://java.sun.com/products/javacomm/javadocs/packages.html. You would need to have atleast 8.1.x Oracle version to use Java. I am not sure how javax.comm will behave under Oracle because of too many security problems may come up accessing COM ports from within Oracle.
/Rauf Sarwar Received on Mon Oct 07 2002 - 21:45:53 CEST