Oracle

Using Oracle Stored Procedures with LightSpeed

Oracle stored procedures return row set results through parameters. In order to locate the row set, LightSpeed adopts the convention that the results should be returned through an out parameter of type ref cursor named “results”.

ODP.NET Versioning Considerations

Depending on your installed version(s) of the Oracle client, when using the Oracle9Odp provider you may receive assembly binding errors for the Oracle.DataAccess DLL of the form:

Could not load file or assembly ‘Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342’ or one of its dependencies. The system cannot find the file specified.

This can be solved using a binding redirect in the application configuration file, of the form:

<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342"
                          culture="neutral"/>
        <!-- oldVersion should be the version that was not found -->
        <!-- newVersion should be the version you have installed -->
        <bindingRedirect oldVersion="10.2.0.100" newVersion="2.102.2.20" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

Designer Support

Some third-party add-ins which integrate Oracle into Visual Studio (such as the Devart DotConnect add-in) use a connection string format which is not understood by LightSpeed. If you encounter problems when using such an add-in, create a new Server Explorer connection using the .NET Framework Data Provider for Oracle or the Oracle Data Provider for .NET.