This content has been marked as final. Show 3 replies
i have a table A in which there is a field signature i have defined ita datatype as varchar2(4000).LONG
earlier the value i am inserting in this was aroung 3500 bytes but now its going upto 3960.so on inserting its throwing error.
now what should i do as my signature is increasing but the maximum value for varchar2 is 4000 in oracle 10g
Please do not use LONG datatype but use CLOB datatype instead:
Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB) instead. LONG columns are supported only for backward compatibility.
Oracle also recommends that you convert existing LONG columns to LOB columns. LOB columns are subject to far fewer restrictions than LONG columns. Further, LOB functionality is enhanced in every release, whereas LONG functionality has been static for several releases.
Edited by: P. Forstmann on 7 juin 2011 13:45