Friday, May 26, 2006

Creating a PL/SQL Web Service from Oracle XE Database

If you want to use Oracle JDeveloper 10.1.3 to publish Web services from PL/SQL packages you will come across this gotcha'.
Oracle XE (Oracle 10g Express Edition) does not come with SQLJUTL. This is used by JDeveloper to publish the Java wrappers around a PL/SQL package for exposure as a Web service. But the workaround is simple.
In the <jdev_home>\sqlj\lib directory there is a copy of sqljutl.sql
Load the package in sys schema (the script contains 2 packages - you don't need the sqljutl2 package - it will not compile if you try and load it) and grant execute to public and carry on using the great PL/SQL Web Service Generation features that JDeveloper offers.