DevOps, CI/CD and Automation

Hi

We have a application (c code) that currently uses a ISAM file based DB.

We want to replace this with Oracle9i.

My thoughts would be to create Oracle OBJECTS data types and use the OTT utility to automaticaly create the associated c structs.

We could then create wrappers around the existing c modules that interface to the ISAM tables & point them to Oracle using the new c structs.

What I need to get a better picture on is the pros & cons of using:
- PROC*C
- OCI

What benefits are there in using embedded PL/SQL with either technology?

Are there any other tools that I could use to map the Oracle9i entities to the relevant c structs?

Any thoughts or tips based on your experience would be greatly appreciated.

Cheers Luie