Recursive queries are something I have used many, many times over the years to build dynamic, n-tiered hierarchies. Oracle’s CONNECT BY PRIOR is awesome. Does anyone know if this is possible in SQL Server or MySQL? From what I understand, stored procedures would need to be used in MySQL and SQL Server to accomplish what Oracle does in one SQL statement with CONNECT BY PRIOR. I need to dig into the other databases a bit further to verify, but I am interested in any elegant solutions people have come up with if you would like to share.
Oracle Portal Broken with iPhone
SSL with Oracle Application Server WebCache and iPhone The latest iPhone update appears to have broken some SSL-enabled OracleAS sites. We have been working through finding a solution for an Oracle Portal customer of ours and it has been fairly hairy. On at least one of the environments, we have found a solution. We can likely help if you have been having an issue with your SSL handshakes.
SQL to Query Oracle, Return XML – with SQLX
Like many days, I had a need to query data stored in Oracle. But today was different. I needed to return the data in an XML format. I started with a very simple need and generated the XML brute-force while traversing my cursor. However, I realized the data would not be escaped properly and knew/assumed Oracle has created built-in functionality to accomplish what I was trying to do. I then recreated my logic using DBMS_XMLGEN. This worked well, in that it created the desired result set, but I hate the idea of storing SQL in a string to be passed … Read More
OID Install in Oracle Enterprise Linux (OEL) 5 – Shared Libraries Error
When installing 10g OID on OEL5, if you run into the following error, you can run the below commands to address the issue: Error: OPMN HTTP process fails to start. When you look in the log file, it says: /Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory To fix, run the following commands: # ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2 # chmod 755 /usr/lib/libgdbm.so.2.0.0 # chmod 755 /usr/lib/libdb.so.2
Complete Fusion Middleware 11g environment setup
We have recently been working on and completed an entire Oracle Fusion Middleware 11g environment setup for a customer: Identity Management WebCenter (Framework and Services) SOA Suite UCM This article is part of the recent work short blurb series.
Deciding where to use BPEL vs ESB
I just had a discussion with an M&S SOA Architect about the advantages and disadvantages of BPEL vs ESB, and more importantly, where to use which in practical business scenarios. This article is part of the recent work short blurb series.
OBIEE for the iPhone
We recently had a customer request help with configuring OBIEE for use on both PCs and mobile devices (specifically, the iPhone). Of course, this is possible, but Oracle does not have a clearly documented approach. You might think that a separate server is required to accomplish this. However, the fact is that you can actually use a single server to deliver OBIEE reports for both PCs and the iPhone. For those interested, following is a link to the Oracle OBIEE Indicators iPhone Demo: Please browse our OBIEE Consulting Services This article is part of the recent work short blurb series.
Oracle IdM – SAML SSO with Google Apps
We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against OID even while accessing Google Apps assets!