Consuming Web Services from PL/SQL – Part II: A pure PL/SQL solution using UTL_HTTP (Oracle 9i or 10g)

Lucas Jellema 24

This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of the UTL_HTTP supplied package. In this article we will create a PL/SQL Function that builds the entire SOAP message, inserts parameter values, invokes the WebService through UTL_HTTP and returns the […]

Check your XML online

Hans Rabouw

Yesterday I needed to validate some XML against a schema definition. I had a tool for that at hand, but alas, it failed to work. Looking for another way to do it I came across this site where you can check the validity of the xml online.

Comment from Steven Feuerstein

Harm Verschuren 1

In the Oracle Magazine of januari/februari 2005 Steven Feuerstein wrote an excellent article about Refactoring for PL/SQL Developers. In this article he uses technologies known in the Java community: Refactoring of code, and reapplies these in PL/SQL. Both languages are programming languages so it is perfectly OK to interchange the […]

MERGE!

Maarten Schutgens 5

When I was confronted with the challenge to import about 260 tables from two different Rdb’s into a single Oracle database (9.0.1.x) on a daily basis via a database link my first thought was: Oh no, I am not going to write 260 times two individual DML statements, one UPDATE […]

AMIS Query – Oracle BPEL Process Manager Dissected (Thursday 27th January)

Lucas Jellema

BPEL is emerging as the standard for assembling a set of discrete services into an end-to-end process flow, radically reducing the cost and complexity of process integration initiatives. The Oracle BPEL Process Manager offers a comprehensive and easy-to-use infrastructure for creating, deploying and managing BPEL business. Oracle BPEL PM has […]

Pivoting in SQL using the 10g Model Clause

Lucas Jellema 4

In this post we discuss pivoting of records in SQL – either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) and fairly complex, tricky SQL statements. In Oracle 10g, using the MODEL clause, there is a clean, fairly straightforward way to achieve elegant pivoting – even nested pivoting – in single SQL statements. This post shows the pivot operation using the Model clause.

Oracle Open Source : SQuirreL

Alex Nuijten 1

Not too long ago my colleague Zeger Hendrikse gave this presentation on Open Source Databases. Part of this presentation are the Tools available. One of the Tools he mentioned also has an Oracle Plugin available. So, continuing the story on Oracle and Open Source, may I present to you: SQuirreL