January 2009
1 post
Enabling SSL for Oracle HTTP Server
Enabling SSL for the HTTP server is a relative simple task, and the essential steps are described next. 1) Edit the “opmn.xml” file (don’t forget to make a backup copy). You can edit this file via the OEM or manually (via shell). Access the Oracle Entreprise Manager (http://your_server:1810) and at the bottom of the page, click the link that reads “Process...
Jan 13th
December 2008
1 post
FTP and SFTP on the Database...
When designing your application with an Oracle database, you may find more productive to trigger FTP jobs from inside the database itself. If you rely on simple FTP protocol, you can use two main approaches: Build a Java procedure to run shell scripts (with a PL/SQL wrapper), like the one available here, and invoke a third party FTP software. This option has the advantage of less code to manage,...
Dec 9th
November 2008
1 post
Using the UTL_DBWS Package
In my previous post, I mentioned the UTL_DBWS package, that provides a ready to use method to consume web services from the database itself, using pure PL/SQL. Although you only need PL/SQL to consume, the package itself is based on a couple of java classes. If you’re using a 10.1 or 10.2 database, the PL/SQL code is already installed, but the Java package isn’t! This will cause an...
Nov 5th
October 2008
2 posts
Consuming Web Services using PL/SQL
For the last couple of days..I’ve been studying how to consume web services within the Oracle database using PL/SQL.. A quick glance at my personal library (Google!)…led me to conclude that there are two major ways to do this: Build your own SOAP API using the UTL_HTTP package for the HTTP requests (mandatory for anyone using 9i or older) ; Use the UTL_DBWS package available in...
Oct 25th
Starting....
Hi there… For the last few months, I’ve working as ORACLE developer and doing some DBA related tasks…. Since I’ve come across some interesting issues…often not exposed on the web as they should…simply not concise enough…or perhaps to serve as reference to future developers…since I have found personal blogs about Oracle to be very useful… ...
Oct 22nd