Posts tagged plsql
Database development in the Oracle Database is crucial for creating well balanced multi tier applications. This presentation describes a number of useful facilities and application architecture considerations around the database, taking into account some of the most recent insights.
The official slide deck from this presentation at Oracle Open World 2012:
On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem I ran into was the character encoding of the XMLElement function, which eventually was worked around with UPDATEXML.
In this blog post I would like to share with you several attempts to solve this problem, why they failed and the final solution to the problem.
Printing of official documents happened in a separate printing module. Whenever a document needed to be printed, an XML document was generated in a database query and sent to the printing module. Most of the data came from relational database tables, but pieces of standard text were supplied as XML documents by another party… and saved in our database in an XMLType column based on CLOB storage.
Our printing module expected to find these standard text XML documents within a tag in our generated XML document. Also both XML documents, our generated XML and the supplied XML, had different namespaces, this needed to maintained this way. The Oracle database version we were working with was 10.1.0.5.0.
In this post I will use a simplified version of the real XML More >
Reduce occurrence of ORA-04068 while upgrading PL/SQL packages by moving global variables to Application Context0
This article will argue against the use of (stateful) global PL/SQL variables – as they are both a potential problem for stateless web applications and the availability experienced by end users during database upgrades.
In various database releases, Oracle did a lot of work in supporting online redefinition of database objects, striving to a reduction of the impact of changes both in terms of unavailability (through locks) and invalidation of dependent objects. When a table is redefined online, it is accessible to both queries and DML during much of the redefinition process. The table is locked in the exclusive mode only during a very small window that is independent of the size of the table and complexity of the redefinition, and that is completely transparent to users. Through fine grained dependency tracking, the number of occasions on which dependent objects are rendered invalid is reduced to those situations where it is really justified. In database releases prior to 11g, object dependencies were managed at the object level, so altering an object automatically invalidated all dependent objects. Oracle 11g has more granular dependency management, so only changes that directly More >
While building a (new) ADF 11g application you sometimes have to deal with the fact that you have to use existing PL/SQL procedures for storing your data.
This article describes how you can overwrite your ADF business component’s default behavior to execute its DML statements using PL/SQL stored procedures.
There are a few steps we have to make:
- Create a new Fusion Web Application and connect to the HR database
- Create Entity and View for the REGIONS table (or based on a view if you like)
- Create abstract class (PlSqlEntity.java) that will be the baseclass of all entities that use PL/SQL for its DML. This class will also contain a helper method for executing stored procedures
- Make the REGIONS Entity extend our PlSqlEntity and implement the abstract methods
Veel PL/SQL ontwikkelaars hebben (n)iets met Java. Aan de ene kant zien ze dat Java op veel plekken wordt gebruikt, binnen en buiten de Oracle technology stack. En dat kennis van Java af en toe best handig zou kunnen zijn – zeker als je als klassiek Oracle ontwikkelaar gebruik wil maken van moderne technologie en je misschien wel een doorstart in je carriere overweegt. Maar aan de andere kant is de drempel om echt met Java aan de slag te gaan enorm hoog. Die hele wereld van Java en Java ontwikkelaars hangt aan elkaar van oneindig veel acroniemen, eigenwijze nieuwkomers die van een database niets moeten hebben en die dreigende schaduw van de Object Orientatie. Veel PL/SQL ontwikkelaars hebben wel eens naar Java gekeken, maar lang niet allen is die eerste kennismaking heel goed bevallen.
Met deze achtergrond in gedachten organiseert AMIS op donderdag 5 april een evenement waar PL/SQL ontwikkelaars de kans krijgen om (opnieuw) met Java kennis te maken.