Hmm...here I thought I had to do all this special type handler stuff and all I did was:
- remove my OracleLobHandler injection in the SqlMapClientFactoryBean from the applicationContext.xml file - remove the typeHandler attribute from my OUT parameter of type clob - remove the resultClass from the procedure tag Called my login function and the CLOB of XML was returned perfectly. I can't believe I didn't just try the most basic way first...based on all of the forum entries and documentation I just assumed that CLOB handling for an Oracle database was inherently complex...not so much in this case. Phew! -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean. -------------------------------------------------------- This message contains information from Merlin Securities, LLC, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. Merlin Securities, LLC is a registered broker-dealer. Services offered through Merlin Securities, LLC are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Merlin Securities, LLC and may lose value. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security.
