Very Computer

For example,

 write_line(...some text string ...);

 procedure write_line(str in varchar2)
 is
  begin
   global_doc_buffer:=global_doc_buffer||str||chr(10);
  end;

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...

thanks
jason

Try using a temporary CLOB (assuming you are on 8i).  These have a 4G limit.

Quote:> 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
> table.

> For example,

>  write_line(...some text string ...);

>  procedure write_line(str in varchar2)
>  is
>   begin
>    global_doc_buffer:=global_doc_buffer||str||chr(10);
>   end;

> 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...

> thanks
> jason