> anyone test inserting a blob into an Oracle DB via CFMX?  Supposedly 
> this works now but I'm getting an error message:
> 
> "[Oracle JDBC Driver] The hexadecimal string is invalid"
> 
> SQL is 
> INSERT INTO foo
> (ct, bob)
> VALUES
> ( '55', <cfqueryparam cfsqltype="CF_SQL_BLOB" value="#tmp#">)
> 
> where tmp is a Word doc grabbed via CFFILE.
> 
> Cheers!
> 
> --
> Douglas Knudsen
> Alltel Corporate
> CIS Group
> 678-351-6063
> "Spoon feeding in the long run teaches us nothing but the shape of the 
> spoon." - E.M. Forster 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253900
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to