Category: PL/SQL
Every once in a while you run into a SQL challenge that seems extremely simple at first glance and turns out to be not so very simple when you …
Last week I delivered a Forms module which invoked the Oracle Reports server by submitting report requests displaying the report on the screen using the Web.Show_document procedure. One thing …
With the advent of the Oracle 7 RDBMS – 1993 – a new era dawned. Many of the key database functions and facilities, such as (Enforced) Integrity Constraints, Stored …
For a customer had to create an Oracle Forms functionality which would need to make several requests to the Oracle Report Server. The customer wanted me to generate a …
In this blog, Steven Feuerstein writes about PL/PDF, a pl/sql library to generate PDF files. Sounds very interesting. It seems very easy to use, as is shown by an …
Next in my series on Design Patterns and their implementation in PL/SQL – also see previous articles on Dependency Injection of Values, Dependency Injection of Interfaces and the Template …
Last week, my colleague Marcos guided us through the still relatively new Oracle offering called XML Publisher. During a session of our Knowledge Center on Oracle Development Tools, we …
Tired of writing only administrative applications? Try a Forms game.
We at AMIS have a fairly long tradition when it comes to having developers attend the annual ODTUG (Oracle Development Tools User Group) conference. My first conference – while …
Oracle biedt sinds Oracle 8i via het package DBMS_PROFILER ondersteuning voor profiling. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden …
After quite a few encounters with .NET in recent years, primarily up against Java/J2EE technology – and some with VB before the release of .NET in 2002 – yesterday …
In the last months we have been busy building and extending a webforms application (10g rel 2) to integrate with Oracle InterConnect. The webforms application is a home-build application …
In a previous article, I discussed Dependency Injection (aka Inversion of Control and the Hollywood principle) and more specifically an implementation of Dependency Injection in PL/SQL. In that we …
These days I am working on a series of articles discussing Design Patterns and their implementation in PL/SQL. In previous articles, I have discussed Aspect Oriented Programming and Dependency …
A little while ago, Jonathan Lewis presented a three day seminar in The Netherlands. You may have read other blogs on this site about this seminar. AMIS had sent …
Frequently our code has dependencies. Some are intrinsic dependencies, like the packages we need to invoke and the type definitions we rely on. Other dependencies are more like configuration …
Historically, when you wanted to connect to an Oracle database you could not get around downloading and installing a bulky Oracle client. Since 2 years already an alternative exists: …
One of the hottest topics in Java programming right now is probably Aspect Oriented Programming. Made popular by frameworks such as AspectJ and Spring, AOP refers to a new …
It is not well-known how the Oracle built-in Soundex exactly works. This article explains the basics and also describes the Dutch variation of this algorithm.
Oracle biedt sinds Oracle 8i via het package DBMS_DEBUG ondersteuning voor debugging. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden …
One of my colleagues needed a simple report on the Entities with their Attributes as defined in an Oracle Designer Repository. Having spent far too much time in the …
A while ago on the SQL and PL/SQL forum on Oracle Technology Network someone asked a question regarding a pivot query. Because the question was justed posted I was …
Steven Feuerstein and his team bring the world a new gift: Qute – the Quick Unit Test Engine. Steven says: “Qute is the Quick Unit Test Engine. It is …
AJAX opens up a lot of possibilities – that in truth by and large already existed pre-AJAX. In a series of articles, I am discussing the concept of post …
This article discusses a generic method for Post Loading Resources in HTML pages. What do I mean by that? Just as your browser will fire additional requests, to potentially …
This article came about as a result of the questions asked by Victor Bax with regard to an earlier post: Oracle Designer – Script for verifying the privileges assigned …
The new Raptor tool for Database Development contains a feature called Snippets. Snippets are predefined fragments of SQL or PL/SQL code that you can easily include in a piece …
Project Raptor, announced and demonstrated at Oracle Open World, this Fall, has now been released (sort of, as it is still an early adopter release). A free download (60Mb) …
Do you know what it sounds like when a production system comes to a grinding halt? It sounds like a telephone ringing. Actually it sounds like a dozen phones …
For the Designer 10g/WebForms 10g project I am involved with, we had a rather unappealing task to allocate. It involved an unknown number of items prompts that ended with …
Did you (or one of your customers) ever encounter ORA-00942 (table or view does not exist) while working in a (Web) form? No, then you can skip this post. …
JHeadstart can generate a number of powerful search facilities, such as the Quick Search widget and Advanced Search area. It supports several different serach operators such as contains, like, …
Virtual Private Database is a quite powerful concept. It lets you set up a mechanism in the database that dynamically appends additional filter-conditions to the queries performed by end …
Yesterday I had a few mind boggling experiences with Oracle Lite. Together with our customer and my colleague Arjaan, I tried to install Oracle Lite. This is a very …
This article serves two purposes: it extends the JHeadstart Application Generator to set UIX items to "required" based on a new custom Mandatory property – instead of driven from …
In my current project – with Oracle Designer 10g, WebForms, Headstart and CDM RuleFrame, Repository Object Browser, CVS, Oracle SCM and Jira for Incident Management as well as TransferWare …
Finally, I have attended to one of my long running frustrations with CDM RuleFrame: the Business Rule Design Transformer, that key Headstart utility that takes Business Rule definitions in …
For one of our sessions for the Knowledge Center Oracle Server Development I had to prepare a presentation and demonstration on new Oracle 10gR2 features in SQL and PL/SQL …
From previous posts, you may have understood that I have been using VPD policies – Virtual Private Database or Fine Grained Access Control – quite extensively in my current …
The next edition of the yearly reunion of the best (and nicest) Oracle Developers in the world is going to be held from June 17th to June 21st, in …
![Hiding the Web.show_document URL]({"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"} "Hiding the Web.show_document URL")