I am facing a very critical issue when we try to insert a file in the blob column in the Oracle database. Steps for inserting data in Blob column in Oracle. 1) Insert other fields and EMPTY_BLOB() in the Table T1. 2) Getting the byte array of the file and updating the blob column with this value.
Issue: This is working fine with file of size less than 4KB. But if it is more than '4KB' it is giving the following error: "java.sql.SQLException: Data size bigger than max size for this type: 10640"