Charlie, The easiest fix on a windows system is to use the AR System ODBC Driver instead of the Oracle (or other database) driver. The AR System driver is simply an odbc presentation to the remedy api and thus the byte data comes back converted. -Matt Kunkel
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Jiang Sent: Tuesday, July 17, 2007 1:38 PM To: arslist@ARSLIST.ORG Subject: The diary field conversion ** All, I am creating a Oracle XML Publisher report for some forms in Remedy. However, the diary field (CLOB) cause me troubles. Basically Oracle XML Publisher cannot convert those dairy field into Chars to display. Anyone has any ideas? Thanks in advance! Best regards, Charlie Jiang This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated. __20060125_______________________This posting was submitted with HTML in it___ ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
