I want to know how to optimize concat operation for CLOB datatype.
We have a package, which loops through 100,000 records (or more) does lot of validations and again concates with other clob element.
Inside CURSOR loop, we do concatination of the previous elements to the current element.
When I executed the package without concatenation, it executated within minute, but with concat operation it took 30 minutes.
This concatenated string(clob) cannot be converted into temp table or associative array as this returned as CLOB to front end.
Is there any way to optimize the concatenation which results in forming a clob?