Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Óï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

oracle BLOB´ó×ֶζÁд³öÏÖÎÊÌâ

ÏÂÃæÊÇÎÒÔÚÍøÉÏÕÒµÄBLOB¶Áд³ÌÐò£¬µ«ÊÇÒ»Ö±ÔËÐв»³öÀ´£¬ÓÐÒ»ÐÐ
blob = (BLOB)rst.getBlob(1);
Ò»Ö±±¨´í£¬Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odb ......

OracleÅúÁ¿²åÈëÒ»ÄêÖÜÆÚÊý¾Ý

ÎÒÏëÔÚÊý¾Ý±íÖвåÈëһЩÈÕÆÚÊý¾Ý¡£·Ö±ðÓÐyear week start_date end_date ¶¼´ú±í×ÅÊÇʲôÄê·Ý¡£ÔÚÕâÒ»ÄêÀïµÄµÚ¼¸¸öÖÜÆÚ¡£¿ªÊ¼Ê±¼äÊǼ¸Ô¼¸ºÅ µ½¼¸Ô¼¸ºÅ£¨Àý£º2009 1 2008-12-28 2009-1-3£©ÒòΪҪ²åÈëÒ»ÄêµÄÊý¾ÝÈç¹ûÒ ......

¹ØÓÚORACLEÈÏÖ¤¿¼ÊÔ

¹ØÓÚORACLEÈÏÖ¤¿¼ÊÔ¶¼°üÀ¨ÄÄЩ°¡£¿
СµÜ¶ÔÓÚÕâ¸öÈÏÖ¤²»ÔõôÁ˽⣬Ã÷°×È˸ø½²½²¡£
ÎÒ¾ÍÌý˵¹ýÓÐOCPÈÏ֤ʲôµÄ...
Õâ¸ö²»´í£¬Äã¿ÉÒÔÁ˽âÏÂ
http://www.oracle.com.cn/viewthread.php?tid=4834&extra=pag ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ