Using Oracle cursors in WebSphere DataPower SOA Appliances

From the developerWorks archives

Valerie Bennett and Keith Barber

Date archived: January 3, 2017 | First published: June 30, 2010

WebSphere DataPower SOA Appliances are purpose-built, easy-to-deploy network devices that simplify, secure, and accelerate XML and Web services deployments within an SOA. The WebSphere DataPower XI50 Integration Appliance can efficiently communicate with enterprise relational databases such as Oracle, and serve as a broker in an Information as a Service (IaaS) pattern. This article focuses on how the XI50 handles the return value of Oracle cursors, and shows you how to create a stored procedure with a reference cursor output parameter, call the stored procedure, and handle the return value.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.

ArticleTitle=Using Oracle cursors in WebSphere DataPower SOA Appliances