Jump to content
Sign in to follow this  

insert value in a blob Oracle

Recommended Posts



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,



Edited by fabien68
change topic to give a solution

Share this post

Link to post
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

Sign in to follow this  


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.