ODBC SQL SCADA HMI and other random letters of the alphabet
Lots of SCADA packages will do the ODBC/SQL thing to an Oracle database. Wonderware (Intouch) doesn't do it natively, but there is an add-on package in FasctorySuite called InSQL, which is built arround Microsoft's SQL Server. I suspect it could talk to Oracle, too, but I've never been down that path.
Intellutions iFIX (as they call their product these days) does SQL calls fairly well, and can talk to Oracle, even using scipts in Oracle instead of having to embed the SQL call in either a SQT/SQD tag or as a script. With your VB esperience, this may be the best package for you, since Intellution has exposed more of its VBA object model than any other SCADA vendor.
Since you mention AB, Rockwell also has a SCADA package, RSView, which also does ODBC, but usually to a .dbf format. (it's been a while - my info may be out-of-date.)
You may also want to take a look at Rockwell's RSSQL program. If all you are trying to do is move data from an AB PLC into Oracle, this is the package for you! That's all it does (whereas SCADA are usually used as HMIs - interfaces between human and machine), and it does it well and easily and FAST. It monitors the PLC for the trigger condition, then gets the data and puts it in the table. Very user-friendly (asuming you understand AB PLC data structure and SQL, of course). Its only drawback: $$$
As Tom said, there are others. The above are just the ones that I have the most experience wiht.