The one that came with CFMX, to use OCI native drivers for Oracle 8i I need to read some docs, do you know any good one other than that which comes with it? Thanks.
--- Sean A Corfield <[EMAIL PROTECTED]> wrote: > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
