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.
I've encountered similar behaviour with Oracle ODBC drivers on Linux connecting to Oracle 8 on HP-UX, had to run a separate insert/update on the CLOB column and then update the rest of the columns. I was able to retrieve the data once inserted tho. Never got a real fix for it, just had to go with the workaround.
Presumably there's a PL/SQL function that reads in the data given a CLOB reference?
There is a dbms_lob package for PL/SQL which can be used to handle LOBs, but I've never seen it used with a reference id like that returned by your drivers - there are functions which accept the column name as arguments.
Looks like you'll be best off just going with the pure java JDBC drivers. I haven't read the MM statement about Oracle drivers not complying with the JDBC standard, though I do recall hearing about Oracle using some non-standard stuff for LOB handling in Java. Having said that, if it's working, it's working, so maybe things are now standards compliant :)
BTW, why the thin driver rather than the OCI driver?
Mark
-- ** 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]
