web services - How to call an ASP.NET webservice from Oracle? -


how call asp.net webservice oracle, can have stored procedure calling asp.net webservice?

here simple stored procedure calls simple asp.net addition web service oracle gives result of addition of 2 numbers supply oracle.

create or replace procedure sp_wsadd (    p_num1 number,   p_num2 number ) v_invelop_temp varchar2(32767); v_invelop      varchar2(32767); v_request      utl_http.req; v_response utl_http.resp;   v_wsdl_url varchar2(2000):='address of webservice'; v_xml xmltype;  begin     v_invelop:='<?xml version="1.0" encoding="utf-8"?>   <soap:envelope xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">  <soap:body>    <add xmlns="http://tempuri.org/">      <num1>'||p_num1||'</num1>      <num2>'||p_num2||'</num2>    </add>  </soap:body> </soap:envelope>';    v_request:= utl_http.begin_request(v_wsdl_url, 'post','http/1.1');               utl_http.set_body_charset(v_request, 'utf-8');     utl_http.set_header(v_request, 'content-type', 'text/xml');    utl_http.set_header(v_request, 'content-length', length(v_invelop));    utl_http.set_header(v_request, 'soapaction', 'http://tempuri.org/add');    utl_http.write_text(v_request, v_invelop);    v_response := utl_http.get_response(v_request);             dbms_output.put_line('response received');             dbms_output.put_line('--------------------------');                                                                                                                                                                                                                             dbms_output.put_line ( 'status code: ' || v_response.status_code );             dbms_output.put_line ( 'reason phrase: ' || v_response.reason_phrase );    utl_http.read_text(v_response, v_invelop);   utl_http.end_response(v_response);                  v_invelop := replace(v_invelop,'xmlns="http://tempuri.org/"','');                 v_xml:=  xmltype(v_invelop);                 dbms_output.put_line('value='||v_xml.extract('//addresult/text()').getstringval());     commit;     end;     /

the web service stored procedure is

  [webmethod]   public string add(int num1, int num2)   {     return (num1 + num2).tostring();   }

Comments

Post a Comment

Popular posts from this blog

python - How to create a legend for 3D bar in matplotlib? -

Image
given ax = plt.subplot() : ax.bar()[0] can passed plt.legend() . however, ax.bar3d() returns none . how create legend displayed bars? update: passing legend="stuff" ax.bar3d() , calling ax.legend() raises /usr/lib/python2.6/site-packages/matplotlib/axes.py:4368: userwarning: no labeled objects found. use label='...' kwarg on individual plots. warnings.warn("no labeled objects found. " you need use proxy artist legends not supported. this code: from mpl_toolkits.mplot3d import axes3d import matplotlib.pyplot plt import numpy np fig = plt.figure() ax = fig.add_subplot(111, projection='3d') x, y = np.random.rand(2, 100) * 4 hist, xedges, yedges = np.histogram2d(x, y, bins=4) elements = (len(xedges) - 1) * (len(yedges) - 1) xpos, ypos = np.meshgrid(xedges[:-1]+0.25, yedges[:-1]+0.25) xpos = xpos.flatten() ypos = ypos.flatten() zpos = np.zeros(elements) dx = 0.5 * np.ones_like(zpos) dy = dx.copy() dz = hist.flatten() ax...
Read more

java - Multi-Label Document Classification -

i have database in store data based upon following 3 fields: id, text, {labels}. note each text has been assigned more 1 label \ tag \ class. want build model (weka \ rapidminer \ mahout) able recommend \ classify bunch of labels \ tags \ classes given text. i have heard svm , naive bayes classifier, not sure whether support multi-label classification or not. guides me right direction more welcome! the basic multilabel classification method one-vs.-the-rest (ovr), called binary relevance (br). basic idea take off-the-shelf binary classifier, such naive bayes or svm, create k instances of solve k independent classification problems. in python-like pseudocode: for each class k: learner = svm(settings) # example labels = [class_of(x) == k x in samples] learner.learn(samples, labels) then @ prediction time, run each of binary classifiers on sample , collect labels predict positive. (both training , prediction can done in parallel, since problems assumed ...
Read more

php - Dynamic url re-writing using htaccess -

how can rewrite http://mydomain.com/test/master.php?catid=2&subcatid=8 http://mydomain.com/test/master.php/catname/subcat using .htaccess file. once rewritten, how can access these parameters in master.php? note: untested, let me know if doesn't work. rewriterule ^master.php/([a-za-z0-9_-]+)/([a-za-z0-9_-]+)$ /master.php?catid$1&subcatid=$2 [l]
Read more