I was thinking about having a look at reading from and writing to tables in an Oracle DB.
Immediately I thought about using JCA, but then started thinking... Is JCA only a method of running RFC enabled functions? I used JCo before to connect to R3 and run an RFC enabled function to read from tables. Since Oracle is a DB I'm assuming that it doesn't have functions to be run, just tables to be read/written.
So then I'm thinking JDBC. Is this the way for me? I know that using JDBC will require that I have access to Oracle JDBC drivers, are these freely available or proprietary?
Do any of you have experience with this? It sounded as though it would be so straight forward at first....
As always, any help is greatly appreciated.