FAQ.How to avoid trouble connecting to oracle database with SQL Plugin?

Answer: For oracle the most important thing is to point the plugin to the libraries from oracle.

In environment variables, the paths like ORACLE_HOME must be defined.
On Mac OS X you also need to define DYLD_LIBRARY_PATH to point to the dylib files from oracle.

For that you need to modify /etc/launchd.conf for Mac OS X 10.8 and newer.
In older versions those variables in .MacOSX/environment.plist file in user's home.

Another way for the case you bundle things inside your app is to use the LSEnvironment key in info.plist.
In info.plist it looks like this:

<key>LSEnvironment</key>
<dict>
<key>test</key>
<string>Hello World</string>
</dict>