Database Web Services
Samples and How-To
This
page lists various samples and how-to documents related to database
web services. White papers and other collaterals are posted
here.
Database as Web Services provider :
Calling-in Database services
How
to invoke an OWB mapping or process flow as a web service
How To use
Blob in Web Services using JPublisher
How
To use Boolean datatype in Web Services using JPublisher
How To use Refcursor in Web Services using JPublisher
How To load SOAP jars
in the Database
How To use XMLTYPE in Web Services using
JPublisher (to be posted soon)
How To use custom serializers for oracle.sql.*
types not directly supported by Web Services types (to be posted
soon)
Database as Web Services consumer: Calling-out
external Web services
This section describes the steps (readme) and the utilities
for invoking external Web Services from within the Database
(SQL, PL/SQL, and Java DB).
Callout
Users Guide [13-Feb-2009]
Callout Utilities [08-Sept-2006]
Simplifying Database Access
Calling external Web service from
Java Stored Procedures, PL/SQL and SQL [26-Nov-2002]
This sample illustrates calling a Web
Service from within an Oracle9i Database through a simple
implementation of a purchasing module.
Download Now (JAR,
269KB)
Readme
Abstract
Turning external Web Services into
SQL data source using Table Function [26-Nov-2002]
Connection caching, generally implemented
in a middle tier, is a means of keeping and using caches of
physical database connections. This helps in improving the performance
of the applications in the middle tier. This Sample Application
illustrates how to use a Connection Cache in a typical middle
tier application. Runs with Oracle9i
v9.0.1 JDBC Driver and OC4J 1.0.2.2 and above.
Download
Now (JAR, 136KB)
Readme
Abstract
Basic Web service Call-out using PL/SQL UTL_HTTP |
Bookmark
