Perl CGI Scripts - Oracle ORA-01465
Error Troubleshooting
Error Message (from web server error_log file):
ORA-01465 DBD::Oracle::st execute failed: ORA-01465: invalid hex number
(DBD ERROR: OCIStmtExecute)
Solution: This error can occur if the bind variable types are incorrect
(or missing) for the columns of data you are inserting into an Oracle
database. Bind variable type information may be missing within the generated
output scripts if the type of destination database has been changed
on the FileMaker tab of FmPro Migrator without also Migrating and Refreshing
layout information. Because refreshing layout information will cause
the loss of customized data validation parameters, it is important to
have a stable database structure before generating Perl CGI scripts.
In order to insure consistency between each of the files used by FmPro
Migrator, the following procedure should be followed in the following
order whenever changing the structure or type of destination database:
(Step 1) Press the Migrate button - to create migration scripts.
(Step 2) Press the Refresh Layouts button on the General tab (within
the CGI section).
(Step 3) Press the Generate CGI button on the CGI tab.
