16 - Database as web services consumer

Abstract

This chapter describes the Database as Web services consumer. This chapter explains the required steps for turning the database into a Web services consumer and explains how to invoke external Web services from within SQL, PL/SQL, or Java in the database. This chapter considers calling the external Web services from the Oracle database when it is needed to implement applications. It explores the new corporate registry application of the British Columbia government in Canada by exchanging data produced between the Oracle database and its legacy mainframe, which processes part of the application using a set of Web services initiated by database triggers. Static invocation refers to the generation of a Web service client proxy, which is loaded into the database for calling external Web services. This chapter addresses the software pieces and the steps for invoking external Web services from within the database. The chapter concludes that a Web Services proxy Java class generated by JPublisher for each external Web service.