UTL packages

Thumbnail image for How to Keep the Response Body with Non-2xx Responses in UTL_HTTP

How to Keep the Response Body with Non-2xx Responses in UTL_HTTP

Web service error handling options in PL/SQL UTL_HTTP, and how to make use of SET_RESPONSE_ERROR_CHECK to keep the response body with non-2xx responses.

Read the Full Article →
Fuzzy Matching with UTL_MATCH

Fuzzy Matching with UTL_MATCH

Oracle supports fuzzy matching with UTL_MATCH functions based on Levenshtein Distance and Jaro-Winkler Distance. A look at UTL_MATCH functions in action.

Read the Full Article →
Thumbnail image for Access Control List (ACL) in Oracle 11G

Access Control List (ACL) in Oracle 11G

Access Control List or ACL is a security mechanism that defines which users or roles can perform which operations on which data. It is an essential setup in Oracle 11G for running network packages such as UTL_HTTP.

Read the Full Article →
UTL_HTTP to Call a Web Service from PL/SQL

UTL_HTTP to Call a Web Service from PL/SQL

You can call a web service from PL/SQL using the Oracle-supplied package UTL_HTTP. This article demos a PL/SQL script to invoke a web service and read its response into a CLOB. It also describes typical errors you may encounter in web service calls and how to resolve them.

Read the Full Article →
UTL_FILE: Write to file example in PL/SQL

UTL_FILE: Write To File Example and Debugging Common Errors

Example of using UTL_FILE in PL/SQL to write to a file. Plus, ORA errors and solutions to common problems faced with UTL_FILE.

Read the Full Article →