Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem working with htp.htbuf_arr

user521233Feb 27 2009 — edited Mar 6 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2009
Added on Feb 27 2009
15 comments
2,714 views