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

Collapse
4: Re: Inserting a long string constant into a clob from plsql? (response to 1)
Posted by Dan Wickstrom on 02/18/03 02:40 PM
Thanks for the link.  I was assuming that varchars couldn't be longer than 4000 characters, and my string is around 6000 characters.  Assigning the string to a varchar and inserting it directly into the clob works.
Collapse
5: Re: Inserting a long string constant into a clob from plsql? (response to 4)
Posted by Simos Gabrielidis on 02/18/03 02:50 PM
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(