This content has been marked as final. Show 3 replies
The TCP/IP interface to Oracle is undocumented (and hugely complex anyway). You'll need to use a higher layer iterface or setup your own infrastructure.
We need more information about what is available to you inside the PLC.
Can you use Java? If so, perhaps use thin JDBC?
Can you sent HTTP requests? If so you could set up your own Web services to handle this.
If you can only use C or C++, Oracle has interfaces there too.. it's called OCI (Oracle Call Interface) and thats as close to the networking layer as you can get.
Finally if you can use .NET Oracle has a Fully Managed Oracle Data Provider for .NET that you could use.
But if all you can do is super low level network access and none of the above then you will need to set up an intermediary as you mentioned.
982478 wrote:The interface I was speaking of is called "SQL*NET", it's packet level and very complex. Maybe we don't mean the same thing.
Thanks for your reply.
I will check on the OCI. On the other hand, I know you say it's undocumented, but in'ts there any reference guide to the TCP/IP interface? All the PLC does is send a string and get an answer. There isn't much to it.
The simplest way to go is to build your own middle tier, potentially using a web service if constructing HTML requests is easy enough for you.