Hi all,
I'm on Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
We have a table with clob data in it. The length of the data is often more than 4000 characters but never more than 32767 characters.
I have a function that manipulates the data and I notice that it is really slow if the incoming parameter is defined as a clob. It is a lot faster if the in parameter is defined as a varchar2.
I know the sql varchar2 limit is 4000 and the pl/sql limit is 32767. But what is the limit when transferring data from sql to pl/sql? Is it safe to assume that a clob column will be implicitly converted to a pl/sql varchar2 if the size is between 4000 and 32767 chars?
Thanks!
Rop