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 with utl.http(read_text)

640587Mar 15 2011 — edited Mar 22 2011

Hi billy,

I have a problem with utl.http(read_text) ...

I am using this code;

loop
UTL_HTTP.read_text( http_resp, v_d, 32767 );
if (v_d is not null) and length(v_d)>0 then
DBMS_LOB.writeAppend( env, length(v_d), v_d );
end if;

end loop;

but I have error;

ORA-29266: end-of-body reached
ORA-06512: at "SYS.UTL_HTTP", line 1330

Could you please help me?

Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2011

Added on Mar 15 2011

15 comments

2,079 views