You would of course use BLOB to store images. Image is a binary data, storing it in CLOB might render it unusable due to various conversions CLOB is subject to.
That said, maximum size of LOB objects differs a bit among different versions. As far as I'm aware it was at least 4 GB in Oracle 8 and much more (depends on the database block size, but generally counted in TB) in later versions. The size limit applies regardless of what type of data you actually put in. Anyway, you're probably not going to have image so large as not to be able to put it there.
Joined: Feb 07, 2011
I'm trying to insert images into database through JDBC and for doing that I'm reading the image file as a stream of bytes and storing it in a byte array. I'm writing this byte array to the database. When I use BLOB, I'm not able to insert an image whose size is greater than 2kB. An error is being thrown that image size is too large.
How can I insert images of sizes around 300 kB? Please help me out in this regard.