Jump to content

insert value in a blob Oracle


fabien68
 Share

Recommended Posts

Hello,

I was trying to save a richedit field into an Oracle database, in a Blob field, for example saving a word document with picture in a database.  I finally found the solution  - see below . This is a simple example just to save a blob and to retrieve and display a blob in a richedit field.

Please note that:

1) In order to test it, please create a table on Oracle as 

create table test_blob (doc blob)

2) The syntax $recordset.count does not exist as described in http://www.w3schools.com/asp/ado_ref_record.asp. The syntax is $recordset.recordcount. In my example, I use it in a "debug" msgbox.

3) The source is given as example. It's a very bad draft, the goal is just to show how it works. I thought that I can share it.

4) The example that helped me was https://community.oracle.com/thread/195148

Have a nice Day,

Fabien

 example_autoitforum.au3

Edited by fabien68
change topic to give a solution
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...