I have created a new FAQ about the classic invalid column type error.
Check it out and let me know if I have missed anything.
<http://opensource.atlassian.com/confluence/oss/display/IBATIS/ What+causes+an+Invalid+column+type+error+with+Oracle%3F>
Nathan