web services - Timeout error handling using utl_http in oracle -


one please ie

when use utl_http.set_transfer_timeout (180);

how handle situation after timeout , example ws did not respond more 180 sec. should handle that. in requirement.

we should timeout error; , insert sepearte logging table error message.

can please me on this

 utl_http.set_wallet (l_chr_wallet_path, l_chr_wallet_pwd);    -- initializing request.   utl_http.set_transfer_timeout (l_chr_timeout);    l_request :=      utl_http.begin_request (url            => l_chr_ws_url,                              method         => l_chr_method,                              http_version   => l_chr_http_version);    -- setting authentications.   utl_http.set_authentication (l_request,                                user_id,                                password);    -- setting appropriate headers.   utl_http.set_header (l_request, l_chr_usr_agnt, l_chr_usr_agnt_val);   utl_http.set_header (l_request, l_chr_conn, l_chr_conn_value);   utl_http.set_header (l_request,                        l_chr_content_type,                        l_chr_cnt_type_value);   utl_http.set_header (l_request,                        l_chr_content_lgth,                        dbms_lob.getlength (l_chr_req_txt));   utl_http.set_header (l_request, l_chr_trnsf_enc, l_chr_trnsf_enc_val);          l_num_req_bdy_lgth := dbms_lob.getlength (l_chr_req_txt);   l_num_chnk_offst := 1;    while (l_num_chnk_offst < l_num_req_bdy_lgth)   loop      if l_num_chnk_offst + l_num_bfr_size >= l_num_req_bdy_lgth              l_num_chnk_lgth := l_num_req_bdy_lgth - l_num_chnk_offst + 1;      else         l_num_chnk_lgth := l_num_bfr_size;      end if;       dbms_lob.read (l_chr_req_txt,                     l_num_chnk_lgth,                     l_num_chnk_offst,                     l_chr_buffer);      dbms_output.put_line (         'before ws write : ' || 'l_chr_buffer : ' || l_chr_buffer);      dbms_output.put_line (         'before ws write : ' || 'l_num_chnk_offst : ' || l_num_chnk_offst);      dbms_output.put_line (         'before ws write : ' || 'l_num_chnk_lgth : ' || l_num_chnk_lgth);       utl_http.write_text (l_request, l_chr_buffer); -- data => l_chr_req_txt);      l_num_chnk_offst := l_num_chnk_offst + l_num_chnk_lgth;   end loop;    l_response := utl_http.get_response (l_request);          -- print response.   loop      --utl_http.read_line (l_response, l_chr_buffer, true);       utl_http.read_text (l_response, l_chr_buffer, 32000);      l_resp_clob := l_resp_clob || l_chr_buffer;   end loop;    utl_http.end_response (l_response);   dbms_lob.close (l_resp_clob);   dbms_lob.freetemporary (l_resp_clob);   p_o_status := 's';


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more