Designer TAPI triggers fail on SQL MERGE operations
![Designer TAPI triggers fail on SQL MERGE operations]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Designer TAPI triggers fail on SQL MERGE operations")
It turns out that the combination of the Table API (TAPI) as generated by Oracle Designer and MERGE operations using the Oracle 9i SQL Merge statement are not compatible. …
Author: Lucas Jellema
View to select CG$ERRORS from (easing RuleFrame pain using a Table Function)
On my current project I am doing a lot of work with CDM RuleFrame and the Oracle Designer Table API. I just learned that the TAPI cannot survive MERGE …
Poor man's VPD – Virtual Private Database before 8i and in Standard Edition Databases
The concept of Virtual Private Database – aka Row Level Security or Fine Grained Access Control – is quite powerful. Without any impact on the SQL used in the …
Death of the End Date – How LAG and LEAD help fight redundancy
Yesterday just prior to our AMIS Query on ADF Faces I was talking to Toon Koppelaars about quite something else: the end_date column in tables that contain contiguous records …
Summary results for all dates, including the ones that I do not have data for – example of using Partition Outer Join – Oracle10g SQL Feature
Trying to make myself useful by answering some of the questions on the OTN SQL and PL/SQL Forum, I came across this question: Group Above Report problem…not able to …
Oracle Designer and Oracle SCM – Last Date Modified and querying in the ROB
Today I decided to write a small package, an extension, to the Repository Object Browser for Oracle 10g (or 9i) Designer and Oracle 10g SCM. This extension will provide …
Another Pop-Quiz: Whose VPD policy is used when executing SQL in a (definer rights) package?
Virtual Private Database does not let me go. Today I had another burning question to which I could not see the immediate logical answer. I know that when a …
Returning a Ref Cursor based on a PL/SQL Collection
The question on the OTN Forum was: How do i add rows to a pl/sql table and then use the table to open a ref cursor.. Somehow I was …
Good Citizenship – Have Client Applications register themselves with the database
Years ago I have read about the package dbms_application_info for the first time. This is a standard supplied package, shipped with every Oracle Database. It can be used to …
Debugging PL/SQL with DBMS_DEBUG
A very good instruction on the programmatic interface to Orace’s PL/SQL debug facilities. If you do not happen to have a GUI PL/SQL debugger – such as in JDeveloper …
Pop-quiz: VPD policy that depends on a table with a policy…
What happens if the policy function on table A returns a predicate that refers to table B and table B has its own policy. For example: in a Master-Detail …
Select Trigger in Oracle Database – introducing Fine Grained Auditing
Does Oracle provide a SELECT trigger in the same way that we have INSERT, UPDATE and DELETE triggers? No, it does not. However. It does offer something that comes …
Data Profiling with Oracle Warehouse Builder 10gR2 (article in Dutch)
The 10gR2 or Paris release of Oracle Warehouse Builder is attracting a lot of attention. During Oracle Open World 2005 of course, and in a number of Blogs by …
SQL*Plus or Report style Break Groups in SQL Query
Rob just asked me if he could easily create break groups in a normal SQL query, somewhat like BREAK ON in SQL*Plus and break groups in Oracle Reports. The …
Oracle 10gR2 – New Feature: the Rules Manager
I noticed in the Oracle 10gR2 New Features Guide a piece on the Rules Manager. I have not yet figured out what it does exactly. But it certainly sounds …
10gR2 New Feature: DML Error Logging
Just read an excellent overview of the new 10gR2 feature of DML Error Logging: 10gR2 New Feature: DML Error Logging by Natalka Roshak on Oracle FAQ’s. It gives a …
Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)
Oracle SCM – the Software Configuration Manager – provides the backend source code control services for Oracle Designer. It offers among other things functionality for Version Control: Check In, …
Oracle JDeveloper 10.1.3 EA1 New Features
It is not yet a production release, but hey: who cares when you see what it contains in terms of new functionality. Apart from the UIX design time support …
AJAX Tag Library – Open Source project for easy use of AJAX mechanisms from JSPs
I just googled across this open source project. It is relatively simple, but can be quite useful. Its demos are at any rate useful, if only for the JavaScript …
Enhancing PHP-based WordPress Weblog with AJAX driven enrichments
Over the past period I have written several articles on AJAX – the Asynchronous JavaScript and XML mechanism for dynamically updating a web-page based on background communication with the …
Increasing speed of making data available in the web-page – on AJAX, controlling data caching and JavaScript Libraries
The problem I am dealing with: downloading all data that is potentially to be displayed in the client – for example in SELECT LISTS – takes too long to …
Building Check In protection into Oracle Designer/Oracle SCM – Check In only by the user that did the Check Out
One of the peculiarities – that word once took me three minutes to pronounce more or less correctly during a workshop in Melbourne, Australia and I vowed never to …
An Introduction To Ajax – great article on dev2dev
I just came across an article that very clearly introduces AJAX: An Introduction To Ajax Recently I did an internal presentation Enhancing Web Applications with AJAX, XMLHttpRequest, UIX – …
AMIS Query – donderdag 29 september 2005 – Java Server Faces en ADF Faces, van vergezicht tot standaard View technologie
(this event on JSF and ADF Faces will take place in Nieuwegein, The Netherlands and will be Dutch-spoken. Hence this announcement in Dutch) AMIS Query: Java Server Faces, van …
Standard for Database Development – Getting rid of USER from PL/SQL and SQL – no longer is USER equivalent to End User
Many applications built in the Client/Server era made use of the fact that every end user had his or her own Database User Account and every Database Connection and …
Introducing Spring Framework – Overview presentation and demonstration for Oracle Consulting
Last week, I had the opportunity to present on the Spring Framework for the Oracle Consulting Java Professional Community at Oracle The Netherlands. Having worked at Oracle for over …
SQL Question: Find overlap in periods – using Analytical Functions (LAG and LEAD)
Today one of my colleagues asked me “What again was your query for finding overlaps in a table with periods, demarcated by start_date and end_date. I think he was …
Spring and Oracle ADF – registering a POJO Spring JDBC based Business Service as Data Control
In several previous posts, I have wondered about the potential for combining the ADF Binding Framework and the IDE capabilities around ADF in Oracle 10g JDeveloper with the Spring …
JHeadstart Sighting: Steve Muench's Column in Oracle Magazine – Frameworks: Creating Search Pages
Swinging in the sun, enjoying one of this Summer’s last great days perhaps, I was reading the September/October issue of Oracle Magazine. One the interesting pieces this issue was …
Repository Object Browser – Invoking the full property palette for any secondary element
The Repository Reports in the Oracle Designer web-interface Repository Object Browser provide an overview of the most useful properties of the most important components of the elements in the …
Role of the Database in a J2EE Architecture – Dumb Data Store? Only Data Tier? Also Business Tier?
The other day, we had a very interesting debate about the role of the database in (our) Java/J2EE projects and architectures. Should you limit the use of the database …
Introducing Spring JDBC – frequently the best introduction of Spring in an organization
Spring consists of a number of modules, such as the IoC Container, AOP, MVC, Persistence, DAO and Remoting. These modules are relatively losely coupled: some can be used without …
On Line Documentation for Oracle 10gAS 10.1.2 – including ADF Documentation
For the on-line documentation for release 10.1.2 of the Oracle Application Server, see http://download-uk.oracle.com/docs/cd/B14099_10/web.htm. It contains besides others links to documentation on the ADF (Application Development Framework), such as …
Building Custom JSF UI Components – Article Chris Schalk TheServerSide.com
Today I read this very interesting article by Chris Schalk – responsible for the Web application development features within Oracle JDeveloper- TheServerSide.com – Building Custom JSF UI Components. Chris …
Integration between Repository Object Browser and Headstart Utilities Quality Reports
The Repository Object Browser is a valuable web-based interface to the Oracle Designer and SCM Repository, as I discussed in a recent post: Installing the Oracle Designer Web Interface …
Installing the Oracle Designer Web Interface – Repository Object Browser (dig up that little nugget)
One frequently overlooked component of Oracle Designer is its Web Interface: the Repository Object Browser. Added in 2003 to Designer 6i and 9i as well as in 2004 to …
Some small improvements for CDM RuleFrame (including code)
After a year full of stuff like Spring, UIX and ADF, JHeadstart, Struts and JSF, XSL-T and the likes, PL/SQL and SQL, I had a bout of nostalgia this …
Enhancing Web Applications with AJAX, XMLHttpRequest, UIX – Report from An AMIS Ten Minute TechTalk
I was kindly requested recently to do a brief – and it was stressed several times that it really had to be brief, not something I am particularly well-known …
Powercharging FireFox using GreaseMonkey
Today I discovered GreaseMonkey mozdev.org – greasemonkey: home. Greasemonkey is a Firefox extension which lets you to add bits of DHTML (“user scripts”) to any web page to change …
IBM Open Sources WebFountain (UIMA) – Unstructured Text Analysis software
It sounds intriguing. If only I could really get it. IBM has developed software, called UIMA for Unstructured Information Management Architecture, that can be used for analysis of unstructured …