Oracle ORA_1401 and ORA-1461
Error Troubleshooting
Error Message:
ORA-1401 - inserted value too large for column
ORA-1461 - can bind a LONG value only for insert into a LONG column
These errors will occur if the amount of data being inserted
from FileMaker Pro exceeds the size of the Oracle column. One solution
to this problem is to use Oracle CLOB columns to store FileMaker Pro
fields containing large amounts of text (over 4000 characters). When
using FmPro Migrator STD Edition, this feature may be enabled by listing
the Oracle CLOB columns in the Large
Text Fields field on the FileMaker
folder tab.
