problem working with htp.htbuf_arr
can someone please clue me in to what the problem is here? i am attempting to take the output of an htp session and inserting it into a long raw attribute. (please, i know that long raw is depricated but some of us work on legacy systems with specific constraints).
...
v_out_buf htp.htbuf_arr;
v_out_row_count number := 99999999;
v_document long raw;
v_byte_count number;
begin
owa.get_page(v_out_buf, v_out_row_count);
for i in 1..v_out_row_count loop
v_document := v_document || utl_raw.cast_to_raw(v_out_buf(i));
v_byte_count := v_byte_count + length(v_out_buf(i));
end loop;
etc...
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
thanks in advance.
Edited by: user521233 on Feb 27, 2009 4:08 PM