Forum OpenACS Q&A: Re: Inserting a long string constant into a clob from plsql?

How long is the string? If < 32KB, it can be passed as parameter to any PL/SQL stored procedure, and the procedure can insert it into a CLOB with a simple insert statement. If its longer than 32KB, then you'll have to use the DBMS_LOB package.

Have a look at this page and at the parent chapter (both require an Oracle OTN account).