Re: Oracle Clob support?
I have used them with Oracle XE and CF8 Enterprise without any issues. I though do not think I have put very large amounts of data into them in that environment since it is my development environment. You have to use cfqueryparams or at least that is what I found a version or two ago and just have always done it since. On Mon, Dec 22, 2008 at 10:53 PM, Matthew Levine matt.lev...@blueriver.comwrote: Does anyone have any experience storing more than 4000 Chars of information in an oracle clob table field? I'm using the Oracle thin client with Oracle Express and CF8. Any help would be greatly appreciated. Thanks, Matt Levine ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Oracle Clob support?
-Original Message- From: Matthew Levine [mailto:matt.lev...@blueriver.com] Sent: Monday, December 22, 2008 11:54 PM To: cf-talk Subject: Oracle Clob support? Does anyone have any experience storing more than 4000 Chars of information in an oracle clob table field? I'm using the Oracle thin client with Oracle Express and CF8. Any help would be greatly appreciated. In addition to Chuck's comment remember that you also have to enable CLOB support directly on the CF DSN (advanced properties)... that little necessity always seems to bite me in the ass. ;^) Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Oracle Clob support?
Does anyone have any experience storing more than 4000 Chars of information in an oracle clob table field? I'm using the Oracle thin client with Oracle Express and CF8. Any help would be greatly appreciated. Thanks, Matt Levine ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Oracle Clob support?
I believe that OracleXE will only allow a LOB (CLOB or BLOB) to be 32k instead of the 4Gb you get with the purchased version. I'm sure this is not what you wanted to hear, but I think that is the problem you are experiencing. Chuck ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4