In a procedure i am trying to store character data more than 4000 characters. Since, varchar2 doesnt allow more than 4000 bytes. What can be other probable solutions. Tried using CLOB but could get the desired results.
In a procedure, a varchar2 can have a bit over 32000 characters.
As a database column, you can use either a CLOB (normally best), LONG (there's various restrictions on using LONGs and I don't know of any good reasons for using them), or multiple VARCHAR2 columns [eg if you know it will never be more than 8000 characters, you can use two varchar2(4000)].