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

Well, SQL varchar2 is limited to 4KBytes; PL/SQL varchar2 is limited to 32KBytes. (BTW, sorry for the small typo in my previous piece of code; it should be:
:1 := my_proc.new_record(