(Scott Stephens) The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It’s a bit trickier to go in the other direction. I’ve seen a lot of requests for help from developers looking for a way to pass an
Tag: Oracle
Extending PL/SQL with Java Libraries
(Ron Hardman and Michael McLaughlin) Extending stored programs with Java is a very popular solution. PL/SQL is essential to the process of stored Java class libraries. PL/SQL wraps access to the Java class libraries, which means PL/SQL becomes the gate through which data moves to and from Java store
Oracle Upgrades Financial Modules
(Renee Boucher Ferguson) Beefing up the financial modules that complement its E-Business Suite, Oracle Corp. announced upgrades to its namesake Internal Controls Manager and Financial Consolidation Hub.
How Oracle approaches the problem of identity management
(Bob Watkins) Oracle Identity Management is a comprehensive identity management solution that leverages the strengths of its underlying database and application server. It includes centralized and delegated administration over user identities and access to services, provisioning of user services, an
A Whole Lotta Fusion Going On
(Jeff Spicer) Recently, I read the comments of an industry analyst who wrote that Oracle had managed to “mystify the market by naming everything Fusion,” referring to Oracle’s recent product strategy announcements and releases that bear the name “Fusion.” While the analyst has a point—there is in
Oracle, Sun Reaffirm Alliance on Solaris, Java
(John Pallatto) Oracle Corp. and Sun Microsystems Inc., perennial allies in the competition against IBM and Microsoft Corp., reaffirmed that they will continue to work together in the development of Java applications and in marketing Oracle software.
Using Oracle Data Mining to Analyze Sequence Data
Sequence alignment is without doubt one of the most commonly performed bioinformatics tasks. The most widely used sequence alignment algorithm is BLAST (Basic Local Alignment Search Tool). BLAST is a method for rapid sequence comparison that was introduced in 1990 by Stephen Altschul. It is typi
Data Modeling
(Philip Greenspun) Data modeling is the hardest and most important activity in the RDBMS world. If you get the data model wrong, your application might not do what users need, it might be unreliable, it might fill up the database with garbage. Why then do we start a SQL tutorial with the most challe
Integrating PeopleSoft CRM with Oracle E-Business Suite Using BPEL
(Lawrence Pravin) Many organizations have heterogeneous application portfolios that cross different departments, geographic locations, or subsidiaries. While multiple ERP systems may be necessary to meet the requirements of the business unit, they essentially result in data fragmentation. Integratio
Users Unmoved by Oracle Pricing Changes
Users interviewed after Oracle Corp. revamped its multicore-processor pricing model last month seemed largely unimpressed with the move.
