We're using stored procedures for the saving of content in our CF based CMS - we've just switched over from queries. But, we're running across the following error, trying to save a largeish chunk of text to an Oracle 8.1 database using CFEnt 4.51SP2 on Solaris: Oracle Error Code = 1460 ORA-01460: unimplemented or unreasonable conversion requested This happens at about 31k of text - works below that, breaks above it. The procparam tag looks like this: <CFPROCPARAM DBVARNAME="v_storybody" TYPE="IN" CFSQLTYPE="CF_SQL_LONGVARCHAR" VALUE="#FORM.STORYBODY#"> The field in the DB is a "long", the stored procedure is expecting a long. It works fine with a CFQUERY and a CFQUERYPARAM. If I set the MAXLENGTH attribute of the CFPROCPARAM, it makes no difference. I've tried changing the CFSQLTYPE as well, with no help. Is there a known bug/limit to the CFPROCPARAM? I can't find a mention anywhere in Forums or the Allaire knowledgebase. Thanks in advance! -- Edward Smith Internet Broadcasting System Director of Architecture http://www.ibsys.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
