Image insertion into database

[Gvn Karthik]

I have Oracle 10g Express Edition installed. I'm not able to insert images into the database of size greater than 3kB. I want to insert images of higher sizes say 200kB.

When I checked the size of the image column which is of BLOB type, the size turned out to be 4000. That explains why I was not able to insert an image of higher size.

How do I increase the size of the BLOB field so that I can store bigger images?

[Jeanne Boyarsky]

Oracle 10g allows up to 4 gigabytes in a BLOB. The express edition is a different product though and might not allow big files at all.

[Blaidd Gwael]

Have you read: Oracle ?

[Gvn Karthik]

I read the stuff from the links above but I could not create the table successfully. How should I modify the following query to suit larger image insertion?

create table images(imageid number(10), photo blob);