APPS.IBY_NETUTILS_PVT dependencies on DBMS_LOB

Line 470: --dbms_output.put_line('POST BoDY Length = ' || DBMS_LOB.GETLENGTH(p_postbody));

466: --dbms_output.put_line('l_post_info = ' || l_post_info);
467:
468: --dbms_output.put_line('l_host = ' || l_host);
469: --dbms_output.put_line('l_port = ' || l_port);
470: --dbms_output.put_line('POST BoDY Length = ' || DBMS_LOB.GETLENGTH(p_postbody));
471:
472: l_conn := utl_tcp.open_connection(remote_host => l_host,
473: remote_port => l_port);
474:

Line 480: l_postbody_length := DBMS_LOB.GETLENGTH(p_postbody);

476: l_ret_val := utl_tcp.write_line(l_conn,'Accept: text/plain');
477: l_ret_val := utl_tcp.write_line(l_conn,'Content-type: application/x-www-form-urlencoded');
478:
479: -- get the length of the clob
480: l_postbody_length := DBMS_LOB.GETLENGTH(p_postbody);
481: --l_content_len := 0 ;
482: l_content_len := l_postbody_length;
483: l_ret_val := utl_tcp.write_line(l_conn,'Content-length: '||l_content_len);
484: l_ret_val := utl_tcp.write_line(l_conn);

Line 491: DBMS_LOB.READ(p_postbody,l_len,l_pos,l_buff);

487:
488: -- splitting the clob into varchar2 and posting it.
489: WHILE (l_pos <= l_postbody_length) LOOP
490: l_len := 32767;
491: DBMS_LOB.READ(p_postbody,l_len,l_pos,l_buff);
492: l_pos := l_pos + length(l_buff);
493: --dbms_output.put_line('Read :' || l_buff);
494: l_ret_val := utl_tcp.write_text(l_conn,l_buff,null);
495: END LOOP;