4D 2004 was a PPC native application and when the 4D for OCI pluigin was used it required that the Oracle libraries were installed on the machine using the plugin.

Since 4D 2004 was a native PPC application, the PPC version of the Oracle libraries needed to be installed.

4D v12 is an Intel only application and therefore the 4D for OCI plugin will not work with the PPC libraries. The Intel version of the Oracle libraries must be installed in order for the v12 4D for OCI plugin to work on a Mac OS X machine.

Install the Oracle Instant client for Intel Macs and follow the instructions in the Tech Tip Installing 4D for OCI on Mac OS X.

This installs instant Client software (Oracle 10g) in a /Oracle directory, sets up an environment.plist file in a /.MacOSX directory and replaces the libclntsh.dylib (PPC version) in the /usr/lib/ directory with libclntsh.dylib.10.1 (Intel version). All of the steps are described in detail in the Tech Tip Installing 4D for OCI on Mac OS X.

Note: libclntsh.dylib.10.1 should be renamed to libclntsh.dylib when copying to the /usr/lib directory.

After performing these steps, the 4D for OCI functionality should be restored.

The bottom line is that 4D 2004 is a PPC application that runs in Rosetta on Intel Macs. The original libclntsh.dylib was coded for PPC operating systems. 4D v12 runs natively on Intel Macs, requiring a different libclntsh.dylib file coded for Intel (386) processors.