很久没用ORACEL，MDAT是时间型的吧？或者值应该这样写:'2011-8-3 23:32:59.000000'?试一下
INSERT INTO MKP.CON_NOTICE (mdat) VALUES (TO_DATA('2011-8-3 23:32:59','YYYYMMDDhhmiss'))
