From: Michael Neumann <mneumann@...>
Date: 2005-01-21T20:55:51+09:00
Subject: Re: Inserting a blob using the oracle driver

George Moschovitis wrote:
> Hello everyone,
> 
> I am not experienced with Oracle and I have to insert a blob
> to a database. Is there an escape method in the Ruby Driver?
> 
> I would like to do something simple like:
> 
> blob = File.read('blob.bin')
> db.exec("INSERT INTO my_table (the_blob) VALUES ('#{escape(blob)}')")
> 
> Is this possible? Any help will be appreciated!

With the Oracle7/8 driver I used for the DBD::Oracle, you just had to 
specify the type when calling #bindrv as LONG_RAW.

Regards,

   Michael