I'm having a terrible time trying to figure this one out. I have a string (the string contains XML data) that I need to convert into a CLOB to pass into a PL/SQL procedure. I'm using Oracle Objects for OLE (oo4o) for my database access and Visual Basic 6.0 SP5 as my programming environment.

Does anyone know of a way to convert a string into a CLOB? Any clues would be very much appreciated. Thanks!