(Graz) This article covers the basic of transactions. It describes them and gives examples of committing and rolling back transactions. It also shows how to properly trap errors inside a stored procedure using transactions.
Author: SSWUG Research
Best Practices for Consolidation of Oracle on Linux Deployments
There are many reasons to deploy Oracle on Linux. The more important ones are the flexibility and non-proprietary characteristics of Linux. But the key advantage is that the entire server side code stack from the OS to the application layer is supported by Oracle. Using the best practices Oracle has
Using the element for custom serialization
(Andre Tost) For the most part, JAX-RPC assumes that XML elements that occur in a SOAP message should be mapped into Java objects. There are rules for how simple and complex types are mapped, and JAX-RPC implementations typically provide tooling that generates the necessary code to handle this. The
Debugging Options for DB2 UDB Stored Procedures
(Peggy Rader) This article briefly describes your options for debugging DB2 stored procedures on DB2 UDB for Linux, UNIX and Windows V7.2 and V8.1, and for DB2 UDB for z/OS and OS/390 V6, V7 and V8.
DB2 Instance and Fast Communication Manager – Part 2
(Marin Komadina) In the last article, we discovered the DB2 instance memory structure and fast communication manager, together with all of the DBM parameters influencing memory utilization. In this article we we will continue along those lines with an inside view of FCM tuning and troubleshooting te
Migrating Express Applications To Oracle 9i
(Mark Rittman) Oracle Express has for many years been the industry’s leading OLAP server, offering unparalleled functionality, query performance and application support. With Oracle 9i, Oracle has taken the best features of Oracle Express and embedded them in the database kernel. By moving to Or
Can I store my XSL in a stored procedure?
This is kind of an interesting question that I had some fun with. The answer is yes you can store your XSL stylesheet in a stored procedure. This may have some value in that you can manage both your XML output and your XSL stylesheets in one place. This first example is more of an interesting me
XML Data in SQL Server
(Mike Gunderloy) If you’ve been working with SQL Server 2000, you’re probably already familiar with the XML capabilities provided by the SQLXML technologies, a set of add-on libraries for SQL Server. With SQLXML installed, you can return the results of relational queries as XML fragments, use XPath
Valuable Information for IT Professionals
(Brian Moran) IT professionals are inundated with information that isn’t useful for getting their jobs done. Most vendors, including Microsoft, produce in-depth technical information about how things work but fail to produce material that ties all the pieces together. That’s why best practices docum
AppsWorld: Oracle pushes on integration, customer advocacy
(Marc L. Songini) Having slipped from the No. 2 slot in the business applications market to No. 3, Oracle Corp. is taking pains to boost market share. At its AppsWorld 2004 user conference here, officials from the software maker touted the company’s various initiatives, which include boosting in