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
Ïà¹ØÎÊ´ð£º
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÏÂÃæÊÇÎÒÔÚÍøÉÏÕÒµÄBLOB¶Áд³ÌÐò£¬µ«ÊÇÒ»Ö±ÔËÐв»³öÀ´£¬ÓÐÒ»ÐÐ
blob = (BLOB)rst.getBlob(1);
Ò»Ö±±¨´í£¬Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odb ......
ÎÒÏëÔÚÊý¾Ý±íÖвåÈëһЩÈÕÆÚÊý¾Ý¡£·Ö±ðÓÐyear week start_date end_date ¶¼´ú±í×ÅÊÇʲôÄê·Ý¡£ÔÚÕâÒ»ÄêÀïµÄµÚ¼¸¸öÖÜÆÚ¡£¿ªÊ¼Ê±¼äÊǼ¸Ô¼¸ºÅ µ½¼¸Ô¼¸ºÅ£¨Àý£º2009 1 2008-12-28 2009-1-3£©ÒòΪҪ²åÈëÒ»ÄêµÄÊý¾ÝÈç¹ûÒ ......
¹ØÓÚORACLEÈÏÖ¤¿¼ÊÔ¶¼°üÀ¨ÄÄЩ°¡£¿
СµÜ¶ÔÓÚÕâ¸öÈÏÖ¤²»ÔõôÁ˽⣬Ã÷°×È˸ø½²½²¡£
ÎÒ¾ÍÌý˵¹ýÓÐOCPÈÏ֤ʲôµÄ...
Õâ¸ö²»´í£¬Äã¿ÉÒÔÁ˽âÏÂ
http://www.oracle.com.cn/viewthread.php?tid=4834&extra=pag ......