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

401 views

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

posted Feb 3, 2015 by anonymous

Share this question

1 Answer

Store in the form of Blob something like

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

answer Feb 3, 2015 by Salil Agrawal

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

commented Feb 3, 2015 by Balamurugan Kn

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

commented Feb 3, 2015 by Salil Agrawal

...