Daryl,
Can you point me to the documentation for this CLOb problem of which you
speak. Thus far, the only problem I'm aware of is using <cfdtoredproc> to
access a CLOB. But the workaround for that is to use <cfquery> to access
the stored procedure that accesses the CLOB.
ColdFusion Oracle Native Driver began supporting CLOB data type fields for
the cfquery tag in ColdFusion Server 4.5.1 SP 2.
I'd be interested in the documentation that shows other problems with Oracle
Native Drivers and CLOBs, especially considering I'm working on converting
an application that uses CLOBs over to Native Drivers.
Thanks,
-Doug
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Daryl Banttari
Sent: Saturday, March 30, 2002 10:29 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Query Problem
Misty,
Try using the Microsoft ODBC driver for Oracle (seriously!). For one thing,
there is a bug in the way the Oracle native client handles CLOBs (if you're
using them), that the MS driver does not have.
In particular, we've had to tell people with Spectra sites to not use the
native drivers, since Spectra uses CLOBs extensively.
HTH?
--Daryl
----- Original Message -----
From: "Misty Woodward" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 11:38 PM
Subject: RE: [KCFusion] Query Problem
> Returns about 2k records. The whole database is only 430k rows. We are
using
> Oracle native drivers. The application is currently written in server side
> javascript and runs so fast its like lightening. I just find it very odd
to
> be such a difference. I checked on the macromedia boards and Im not the
> first to see this happen, of course no one ever seems to get an answer on
> the boards.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Ryan Hartwich
> Sent: Wednesday, March 27, 2002 11:14 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [KCFusion] Query Problem
>
>
> If it's a big query and uses lots of ram, and your machine is out of ram
> it would have to page the info to the hard drive. But if your run time
> is consistent then that's not it.
>
> Are you using the correct odbc drivers?
>
>
>
>
> ______________________________________________________________________
> The KCFusion.org list and website is hosted by Humankind Systems, Inc.
> List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
> To Subscribe.................... mailto:[EMAIL PROTECTED]
> To Unsubscribe................ mailto:[EMAIL PROTECTED]
>
>
>
>
>
> ______________________________________________________________________
> The KCFusion.org list and website is hosted by Humankind Systems, Inc.
> List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
> To Subscribe.................... mailto:[EMAIL PROTECTED]
> To Unsubscribe................ mailto:[EMAIL PROTECTED]
>
>
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
