Restart the load after you set this at Informatica Admin console-> Integration Service->Custom Properties
If this is not helping then let me know the max length of the column and the data type.
If helps pls mark as correct :)
Veera - Thanks for the Update - I have added the custom property as you suggested and started the load - Now I am getting error like
ORA-26097: unsupported conversion for column EFFECTIVE_DATE (from type 180 to type 12)
Try to revert you changes related to ddl for that table in database and run it.
You may generate the ddl script using infa designer or else can get table column types from DAC.
Once you revert it back to OOB table definition run the load.