This week's book giveaways are in the Refactoring and Agile forums. We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line! See this thread and this one for details.
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"