Which Oracle driver are you using? The one that ships with CFMX or a newer one downloaded from Oracle Tech Net? If you're using CLOB/BLOB data extensively, I'd recommend looking into the OCI native drivers for Oracle 8i.
On Friday, Dec 27, 2002, at 14:52 US/Pacific, Li Chunshen ((Don)) wrote: > Hi folks, > > Here's the scoop, > > System info: > CFMX Prof. Edition on WinXP Prof. machine accesses a > remote Oracle8 Database on Win2K Prof machine; the > datasource connection has been tested to work; CLOB > enabled; Long Text Buffer (chr) > is set to 64000; Allowed SQL: SELECT and SP. > > DB info: > The Oracle table's CLOB column stores binary image > file, which has been converted to Base64 presentation > with ToBase64 function before insertion; the images > size are all less than 64k; > > No problem with CF5 while > Prob desc for CFMX: > When the CLOB data is retrieved and attempted to be > converted back to original binary format with toBinary > function, CFMX throws an err, > "The parameter 1 of function ToBinary, which is now > "/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJC > .. (omitted) > h86A3+N+s7v49/KQpyafj9jwoG/x/0dz8f/2Q==" must be a > Base-64 encoded string." > > Hmmm, what's going on? Thanks. > > DL > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
