I have a pl/sql procedure that builds a document one line
at a time where a global buffer is used to hold the whole
document until its later inserted into long column of a
write_line(...some text string ...);
procedure write_line(str in varchar2)
Problem is that pl/sql only seems to allow me to build
a runtime global_doc_buffer of around 32K.
Isnt there a way of working with string variables in pl/sql
that are larger than 32K? I even thought of breaking it
up but when i do the insert into the long column of
the table I can't seem to append the chunks together
insert into table (document) values(doc_buffer1||doc_buffer2);
If the concantenation is longer than 32K is still dies !!!
Any ideas would be greatly appreciated...