Oracle ORA-932 Error Troubleshooting
Error Message (from web server error_log file):
DBD::Oracle::st execute failed: ORA-00932: inconsistent datatypes (DBD:
oexfet error, e.g., can't select LOB fields using DBD::Oracle built
for Oracle 7) - This error has been observed with DBD-Oracle 1.12 installed
by ActiveState PPM on Windows.
Solution: This error should not be observed with scripts created by
CGIScripter for Oracle databases on Windows servers. Perl CGI scripts
for this configuration are created to use the DBD-ODBC driver in order
to work-around this issue. An alternative solution would be to re-compile
DBD-Oracle to use Oracle 8 client software on Windows.