Inserting a blob using the oracle driver

ruby-talk
1

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!
regards,
George Moschovitis

2

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