Skip to main content
Kofax

Error Calling Oracle Stored Procedure with ODBC

3014434

Question / Problem: 

Why do we get errors when trying to use the Oracle ODBC drivers with KTM, such as: 

13:18:45 [ERROR] -> ServerDesign 1 -> ScriptProject -> IsDuplicateInvoice -> Line# 2044 -> [Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line 1, column 56: PLS-00103: Encountered the symbol "">"" when expecting one of the following: ( - + case mod new not null <an identifier>

Answer / Solution: 

If using Oracle, it is recommended to make use of the complete Oracle client and ODAC. It is not recommended to make use of the Oracle ODBC drivers, either from Oracle or Microsoft. 

KTM can only make use of the of the 32-bit ODBC drivers. KTM is 32-bit based and will encounter issues if the 64-bit drivers are installed on the same machine. 

These are the drivers defined in the Windows ODBC Data Source Administrator (32-bit) under the System DSN tab. 

This is the ODBC Data Source Administrator located at:

    .\Windows\SysWow64\odbcad32.exe
    
If the drivers are defined in the 64-bit version, "ODBC Data Source Administrator (64-bit)", errors are expected.

Note that the 64-bit version has a name and location that makes it appear to be 32-bit:

    .\Windows\System32\odbcad32.exe
    
When launching the 64-bit version, "64-bit" is in the title bar of the dialog. 

Only the 32-bit version of the drivers can be installed. If both the 64-bit and 32-bit ODBC drivers are installed, errors are expected.

The recommended course of action when the 64-bit drivers are installed is to completely uninstall any and all Oracle ODBC drivers. After they have been successfully uninstalled, install just the 32-bit drivers.

 

Applies to:  

Product Version
KTM 6.3
KTM 6.2