I’m working in a complex system that utilizes multiple SQL queries called by several cron.sh script files, printing the data onto php pages.
I will be changing a column from type VARCHAR2(4000) to CLOB, so that the field can expand past 4000 in size. (In Oracle)
I’ve been trying to understand as much of the code as possible to discern if changing VARCHAR2 to CLOB could have any negative or unanticipated side effects. There appears to be no down side to swapping to CLOB from VARCHAR2.
Any opinions or confirmation in this matter?