How Can i Store Image in Binary Format using Oracle 11g Database

Question

I need to insert the image in Oracle DB in Binary Format.

Answer 1

Store in the form of Blob something like

CREATE TABLE  "IMGTABLE"   
(
    "NAME"  VARCHAR2(4000),   
    "PHOTO" BLOB  
)  

Comments

image character length is 160000 i am not able to store using BLOB. I am getting string length error

---

That should not be the case, sizelimit for the blob is 4GB see the oracle documentation https://docs.oracle.com/cd/B28359_01/server.111/b28320/limits001.htm#i287903