top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
109 views

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

posted Feb 3, 2015 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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
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
...