Ibatis Blob Insertion problems

[Jambunathan, Akilaprasad \(Cognizant\)]

Greetings!!!   We are using iBatis (am not sure on the version) along with Oracle 10.1.0.2.0 for one of our project. We are using BLOBs extensively, when we are trying to insert into a table which has BLOBs we are facing some issue. Here are the details you might be looking for.   iBatis XML snipped                   <insert id="insertFile" parameterMap="uploadFile">                                 INSERT INTO                                 FILEUPLOAD ( FILEID , FILENAME , UPLOADDATE, FILELOCATION)                                 VALUES                                 (#fileId#, #fileName#,TO_DATE(SYSDATE, 'MM/DD/YY'), #fileLink#)                   </insert>                                                 <insert id="insertFileEmptyBlob" parameterClass="com.newsamerica.value.ffms.jobinformation.JobAttachmentValue">                                 INSERT INTO                                 FILEUPLOAD ( FILEID , FILENAME , UPLOADDATE, FILELOCATION)                                 VALUES                                 (#fileId#, #fileName#,TO_DATE(SYSDATE, 'MM/DD/YY'), empty_blob())                             </insert>   Exception   Caused by: java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected   Please let me know on what am I doing wrong?   Warm Regards, Akil   This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com