Tip for Mockup Response

Calling Web Services in PL/SQL using UTL_HTTP package

Today we will show how to access data from WebServices directly in PL/SQL, as I promised in the previous article. [Česká verze článku – Volání Webové služby (Webservice) v PL/SQL pomocí UTL_HTTP] For this purpose you need: Tool for development/testing web services. Applying package SoapUI SQL*Plus environment. For our tests will fully comply. Creating a…

Packages UTL_HTTP, UTL_RAW and their use in HTTP GET method

The Oracle database is possible with the package UTL_HTTP UTL_RAW and send/receive queries from a Web server. On a small example demonstrates how to use these packages. (The examples use the package UTL_RAW on the ground that some Web sites, perhaps in combination with the version of Oracle database, Oracle generates EXCEPTION if you use…