OpenOffice.org 2.0 released
“OpenOffice.org 2.0 Is Here” it says on the OpenOffice.org website. Over the past weeks I have been using OpenOffice.org Beta and RCs and I am really impressed by this …
Category: IT
VPD Policy Tester
My VPD policies were causing troubles when I was running the Forms: ORA-28113 Policy Predicate Has Error . I could not easily figure out which Policy it was, as …
Use of TODO tags to quickly generate a tasklist for PL/SQL development
There are quite a few neat tricks we can steal from other technology stacks and communities for use with PL/SQL development. I have recently written an article on AOP …
JFall 2005 – the last bits
At octobre 12, I was one of the employees of Amis that visited JFall. I haven’t been to one of these days before and I really liked the setup …
More JFall highlights: MDA and OCL, Java and scripting, Project Jackpot and the XP Game.
From last week's JFall conference I picked four of the most interesting sessions I visited to report on: Combining the Power of MDA and OCL: Generating Java Code from …
More on JFall 2005
With some of my collegues I attended JFall, one of the two yearly conferences of the NLJUG. I visited the presentations on Mule, Wicket, Spring WebFlow and the newly …
Upgrading to JHeadstart 10.1.2.1
Recently I started on a project that was partly built with JHeadstart 10.1.2 on JDeveloper 10.1.2 (build 1811). Since JHeadstart 10.1.2.1 contains so many new features and JDeveloper 10.1.2 …
Dashboard for Oracle Designer – free extension to Repository Object Browser
It can be both quite useful and rather difficult to monitor the events taking place in Oracle Designer and/or Oracle SCM (Software Configuration Manager). Keeping track of all Check …
Learn Once, Work Anywhere (with Choice) an impression of J-Fall 2005
On October 12th I have visited J-Fall 2005 conference of Java Usergroup Netherlands (www.nljug.org). There have been held many presentations, attended by a large public and it has been …
JHeadstart(10.1.2) – Passing defaults for your bind Parameters
Sometimes you want the query of your view object to be dynamic: you want to be able to pass an argument (a bind parameter) to the where clause of …
JFall 2005
On oktober 12, 2005, a few of my colleagues and me attended JFall, the second Java conference this year organised by NL-JUG, the Netherlands Java User’s Group. Like JSpring, …
PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving
![PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving]({"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"} "PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving")
Source code control for PL/SQL is often discussed in the organizations that I encounter. The database itself will always hold the latest version of the PL/SQL objects we are …
PL/SQL post compiler to fix TAPI – dealing with the 'TAPI cannot deal with MERGE' problem
Recently I wrote a post about the failure of the TAPI (table API) generated by Oracle Designer to work together with Merge operations: Designer TAPI triggers fail on SQL …
Shipment of books – September/October 2005
The latest shipment of books – just arrived today – contains among others: Writing Effective Use Cases (Paperback) by Alistair CockburnPublisher: Addison-Wesley Professional; 1st edition (January 15, 2000); ISBN: …
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. …
Java and AJAX
Philip McCarthy has started a series of articles about implementing AJAX technology in Java applications. The first article is entitled Build dynamic Java applications and has been available since …
SQLX How to easily generate XML
I recently had the need to generate XML files based on data stored in relational tables. This was done via an XML DOM implementation on the project I am …
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 …
Small introduction to SQL*Net debugging [client side]
Say it's that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems. Blast!. What can you do? Once in a …
NetBeans 5.0 BETA released
The NetBeans team announced today the release of NetBeans 5.0 BETA. To download it, visit the NetBeans website, click on Downloads in the menu bar at the top of …
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 …
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 …
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, …
XML technologies
This picture contains a handy overview, with links, of all (?!) XML (related) technologies, specs, acronyms etc. A similar overview is also available for java.
Book Review: Pragmatic Unit Testing
September 20, 2005
Book reviews and Publications, IT, Java, Oracle, Oracle WebLogic Server
No Comments
Title: Pragmatic Unit Testing Authors: Andrew Hunt, David Thomas ISBN: 0-9745140-2-0 pages: 150 This book gives a good introduction into the different aspects of unit testing. It’s easy readible …
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 …
Oracle 10g R2 does not support Oracle Warehouse Builder.
Oracle’s latest database release 10g R2 does not support OWB (Oracle Warehouse Builder). All OWB’s up to and including the current version 10.1.0.3 are not certified by Oracle 10g …