Perl CGI Scripts - Oracle ORA-01008
Error Troubleshooting
Error Message (from Apache web server error_log file on
Windows):
[Oracle][ODBC][Ora]ORA-01008: not all variables bound
Solution: This error should not normally be observed unless the output
code has been manually modified. Do not use the ORA_CLOB or ORA_BLOB
bind variable types when utilizing the DBD-ODBC driver. The ORA_CLOB
and ORA_BLOB bind variable types are intended for use with the DBD-Oracle
driver. Use the SQL_LONGVARCHAR and SQL_LONGVARBINARY bind variable
types for compatibility with Oracle databases accessed thru DBD-ODBC
and DBD-Oracle without requiring changes to the output code.
