The source data comes from Oracle 9i database (a very old application). I am integrating using Oracle Fusion 12.2.1 environment and invoke a web service to send the data to the target system. The DB adapter that comes with the product does not work with Oracle 9i database - I have tried "Execute Pure SQL", Select and both are having issues. Then I handcrafted the jca, xsd, wsdl and properties file. Now I am unable to retrieve VARCHAR data from 9i table but the date and numbers seem to work. Has anyone tried connecting to 9i database from Fusion 12c DB Adapter? Is there a better working approach?
Thanks
Shanthi