Character conversion in CLOB's - Oracle 9i

[Jane3993]

Oracle 9i. (PL/SQL) I have a SP that performs a data conversion of a 10-digit numeric string into a datetime format. The data being pushed through this SP is a CLOB datatype. The problem exists that if the size of the CLOB exceeds 23kb, the SP dies on the very first date conversion. I am almost certain that the point of failure is the size of the CLOB and I don't understand why considering that the CLOB datatype can hold up to 4 Gb of data. Does anyone have any ideas? Any insight is greatly appreciated.

Thanks in advance,
Jane

 

[swampBoogie]

What has this to do with Ansi SQL? It should be posted in a forum dedicated to Oracle.