Oracle library

Projects we know this applies to:

• eMER

• CAMIS (need to check)

• Others?

Different versions of the Oracle library are required for running some applications locally vs deploying them to development, acceptance and prod.

To update the reference to the Oracle library:

1. Open the repos for the project being deployed.

2. Right click the project in the “Solution explorer”.
   Example:
   

   Image Added

3. Select “Properties” from the context menu.
   Example:
   

   Image Added

   
   4. In the reference ensure that Oracle.DataAccess is set to the correct library ODP for local and GAC for Deployments. S
   
   The appropriate library can be selected by using the buttons at the bottom of the reference form.

Once the references have been added a first time, if you need to switch, select “Remove” and then select the appropriate library, according to your purpose (local or a deployment.

To run on your local environment, set the reference for Oracle to the ODP library.

...

Oracle for deployments to development, acceptance and production need to use the GAC version of the oracle library.

oracle library needs to be the “GAC” version (the current library is attached. If needed create a folder with this exact name: v4.0_4.121.2.0__89b483f429c47342

in

C:\Windows\Microsoft.NET\assembly\GAC_64\Oracle.DataAccess

and save the attached library into that folder.

Image Added

Once code has passed testing in your local development environment:

• create a PR for review.

• deploy the code to development. Currently there is no pipeline for this so the deployment has to be done manually.

• Ask another developer to test your code in development.

...