Hi,
We are using 11.2.0.3 oracle version and have a package which has datatypes as varchar but with some amendements to these strings these blow the approx 32k character limit.
Purpose of these is just to hold a string for dynamic sql and use replace functions on it.
Any harm turning the variable to a clob - will test this but at first sight seems functions such as varchar can be used with clob as well.
Thanks