> Are you using the Oracle ODBC driver (i.e. downloaded from Oracle)?
Yes, AFAIK. I installed the Oracle client tools from one of the ten or
so CDs that came with 9i, then set up an ODBC DNS (via Administrative
Tools), selecting "Oracle in OraHome92" (as opposed to "Microsoft ODBC
for Oracle"). Then, in the CF Admin I just created a CF Data source that
uses ODBC Socket and refers to the previous DSN.
> We use
> this on Win2k with CF5 and have no problem with CLOBs (with cfsqltype
set
> to cf_sql_longvarchar). If you are using something else, it's possible
that
> a quick download from Oracle will provide a temporary solution to the
> problem.
Duh. I was trying to insert the CLOB with other values in the record.
Doing a single column update with either cf_sql_clob or
cf_sql_longvarchar seems to be working ok, albeit that when you retrieve
the value and cfoutput it to the page, it's displayed as
"[EMAIL PROTECTED]" (code is below). I've tried "select
read(params) as reportparams", but no dice. Presumably there's a PL/SQL
function that reads in the data given a CLOB reference?
> You should really aim to implement a JDBC solution tho, as using
> the JDBC-ODBC bridge does result in a performance hit.
K, thanks for that. Yeah, thinking about it, it makes sense to get away
from the ODBC Socket if possible - no point in having an unnecessary
layer of abstraction in there.
Code:
=============
<cfset oReport = createObject("component", "Report")>
<cfquery name="qReportId" datasource="dsn">
select max(id) as id
from reports
</cfquery>
<cfoutput>#qReportId.id#</cfoutput>
<cfquery datasource="dsn">
update reports
set params = <cfqueryparam cfsqltype="cf_sql_clob"
value="#oReport.getParameters()#">
where id = #qReportId.id#
</cfquery>
<cfquery name="qParameters" datasource="dsn">
select params
from reports
where id = #qReportId.id#
</cfquery>
<cfoutput>#qParameters.params#</cfoutput>
--
Aidan Whitehall <mailto:[EMAIL PROTECTED]>
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd +44 (0)1695 51775
Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards>
Fairbanks uses anti-spam filtering. If you sent an e-mail and expected
to receive a response but didn't, please call -- it may be that your
e-mail didn't make it to the intended mailbox.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
