Hi Folks, I'm using OTRS with Oracle as database (Am I alone?). We have a problem with attachments when ticket is opened by email (I didn't test via interface). What I can say is that the attach is being correctly saved in my oracle database.
select max(dbms_lob.getlength(content)) from ARTICLE_ATTACHMENT
MAX(DBMS_LOB.GETLENGTH(CONTENT)) -------------------------------- 5378337 This was a movie with 5Mb. The problem is when I want to retrieve this attach. I can only recover 75Kb. Anyone can help me? Best Regards, -- Ivã D. Boesing ------------------------------------------------------------ Oracle Certified DBA ivan@immediate.com.br Tel.: (51) 3212 8444 / (51) 9177 5620 Immediate Consultoria e Sistemas Oracle Certified Partner www.immediate.com.br ------------------------------------------------------------