Re: Oracle 11g Upgrade Unable to select from CLOB datatype
Which version of CF are you using? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 5 November 2010 15:50, Noveta Wimbley noveta.wimb...@sjcd.edu wrote: We have just upgraded from Oracle 10g to 11g. Now we have an application that will not select from clob datatype column. We are getting the following error: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read. The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line 1 1 : cfquery name=getTXT datasource=prod 2 : select 3 : ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Oracle 11g Upgrade Unable to select from CLOB datatype
CF8 -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, November 05, 2010 7:31 AM To: cf-talk Subject: Re: Oracle 11g Upgrade Unable to select from CLOB datatype Which version of CF are you using? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 5 November 2010 15:50, Noveta Wimbley noveta.wimb...@sjcd.edu wrote: We have just upgraded from Oracle 10g to 11g. Now we have an application that will not select from clob datatype column. We are getting the following error: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read. The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line 1 1 : cfquery name=getTXT datasource=prod 2 : select 3 : ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Upgrade Unable to select from CLOB datatype
CF8 doesn't support Oracle 11G, so you may be out of luck getting any official resolution. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 5 November 2010 21:24, Wimbley, Noveta noveta.wimb...@sjcd.edu wrote: CF8 -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, November 05, 2010 7:31 AM To: cf-talk Subject: Re: Oracle 11g Upgrade Unable to select from CLOB datatype Which version of CF are you using? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 5 November 2010 15:50, Noveta Wimbley noveta.wimb...@sjcd.edu wrote: We have just upgraded from Oracle 10g to 11g. Now we have an application that will not select from clob datatype column. We are getting the following error: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read. The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line 1 1 : cfquery name=getTXT datasource=prod 2 : select 3 : ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm