Difference between CLOB and BLOB
Hey all,
I wanted to find if there any significant differences between the Oracle CLOB and BLOB datatypes. I currently have a couple of tables that contain columns of CLOB datatype. I have been notified of a proposal to change those datatypes to BLOB and find out what impact that would have on the the loading procedures we have on hand. I have two procedures, one that loads data from xml files into the several database tables and one that loads csv files into them. Both of these procedures, when executed, will load the tables and out of all the fields that will be populated, there are a few that will be loaded with quite a bit lines of text. These fields currently are set to CLOB and I am to analyze how changing them to BLOB will affect the procedures and loading. What are the main differences between these two data types that can drive conversion from one to the other?
Any feedback would be appreciated. Thanks.