Any Oracle folks out there still? I'm getting this error
[Macromedia][Oracle JDBC Driver][Oracle]ORA-22275: invalid LOB locator
specified
When executing this SQL in a CFQUERY tag
SELECT XMLElement("state",XMLAttributes(state as "state", abbreviation as
"code")) AS elem
FROM flexuser.states
ORDER BY state;
The SQL executes perfectly in SQL+, SQL Developer, and in the Oracle XE web
based admin tool. The SQL ran fine via CFQuery in CF7, but its bombing with
the above in CF 8,0,1,195765. Yup, CLOB and BLOB support is on. I suspect
the driver, maybe it got updated in CF 8? Its not critical to get it
working, its a example of generating XML in Oracle directly to feed a UI.
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
To unsubscribe from this list, simply email the list with unsubscribe in the
subject line
For more info, see http://www.affug.com
Archive @ http://www.mail-archive.com/discussion%40affug.com/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
