oracleʹÓÃutl_httpµÄÎÊÌâ
declare
soap_request varchar2(30000);
soap_respond varchar2(30000);
http_req utl_http.req;
http_resp utl_http.resp;
BEGIN
soap_request:= ' <?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://service.common.rxn.dbs.com">
<soap:Body>
<tns:retrieveFAX>
<tns:umeroId>f001 </tns:umeroId>
</tns:retrieveFAX>
</soap:Body>
</soap:Envelope>';
http_req:= utl_http.begin_request( 'http://XXXXXXXXXXXX:8080/ipe/services/retrieveFaxService' , 'POST' , 'HTTP/1.1');
utl_http.set_header(http_req, 'Content-Type', 'text/xml; charset=utf-8');
utl_http.set_header(http_req, 'Content-Length', length(soap_request));
utl_http.set_header(http_req, 'SOAPAction', 'urn:receiveFAX');
utl_http.write_text(http_req, soap_request);
http_resp:= utl_http.get_response(http_req);
utl_http.read_t
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÇëÎÊÒ»ÏÂ,C# winformÖÐͨ¹ýOleDbCommand,Ôõôµ÷ÓÃoracle·µ»ØÓαêÀàÐ͵ĺ¯Êý?¼±!!!
/// <summary>
/// Ö´Ðдø²ÎÊýµÄ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯
&nb ......
ÎÒÓÐÒ»ÕűíÓиö×Ö¶ÎÃû³ÆÊÇstarttime ÀàÐÍÊÇDATE ,ÆäÖÐÓÐÒ»ÐеÄÖµÊÇ"11:00:00",ÎÒÏë°ÑÕâÒ»ÁÐÑ¡³öÀ´,Óï¾äÈçÏÂ:
select * from routebanci where starttime='11:00:00' and routename='*** ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÎÒÏëÔÚÊý¾Ý±íÖвåÈëһЩÈÕÆÚÊý¾Ý¡£·Ö±ðÓÐyear week start_date end_date ¶¼´ú±í×ÅÊÇʲôÄê·Ý¡£ÔÚÕâÒ»ÄêÀïµÄµÚ¼¸¸öÖÜÆÚ¡£¿ªÊ¼Ê±¼äÊǼ¸Ô¼¸ºÅ µ½¼¸Ô¼¸ºÅ£¨Àý£º2009 1 2008-12-28 2009-1-3£©ÒòΪҪ²åÈëÒ»ÄêµÄÊý¾ÝÈç¹ûÒ ......