I just worked through an issue like this. When using the CLOB in a select
or where clause, you will need to use the oracle function:dbms_lob.instr()
For example, on one of our Spectra sites running in oracle, the
longcharfield of the properties table is a CLOB. To match a particular
record from that table, we use the following:
<CFQUERY name="qry_test" datasource="#REQUEST.CFA.OBJECTSTORE.DSN#">
select
objectID
from
properties
WHERE
dbms_lob.instr(longchardata, '#HEADLINE#')>0
and
propertyname='HEADLINE'
</CFQUERY>
Hope this helps.
At 09:30 AM 5/11/01 -0700, you wrote:
>I have defined a column as CLOB in an oracle 8i table and when CF
>return "Unknown Data Access Error" when i do an query on this table.
>
>If i remove the CLOB column from the table the query works fine.
>
>Anyone has suggestions to resolve this problem.
>
>thanks
>
>
>
>
>--------------------------------------------------------------------------
>Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
>Sign-up today at http://www.hotvoice.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
