Invoking Webservice from PL/SQL （UTL_DBWS&UTL_HTTP）

从PL/SQL,Oracle提供了两种方式调用外部Webservice：一种是UTL_HTTP，另外一种是UTL_DBWS。

• utl_http – low level http assembler
• utl_dbws – high level web service package

UTL_HTTP

•Available as of 8.0.5

•Send/receive raw HTTP request/responses to external servers

•Advantages:

– Simplistic

–Installed (completely) in the database

–Passed and returns a VARCHAR2 XML payload