Debugging PL/SQL met DBMS_DEBUG (dutch)
![Debugging PL/SQL met DBMS_DEBUG (dutch)]({"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"} "Debugging PL/SQL met DBMS_DEBUG (dutch)")
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 …
Category: Languages
Quick Query to report on Entities and Attributes in Oracle Designer
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 …
Oracle buys Sleepycat
It becomes stranger and stranger. After bying the open source company InnoBase, Timesten, and others, Oracle now also bought SleepyCat. Oracle also released its own freeware in the form …
Does a simple in-line view affect performance?
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 …
Qute – new Unit Testing Engine for PL/SQL (successor for utPLSQL)
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 …
HTML Post Loading and Processing Resources using AJAX – Part 3: multiple, dependent resources and custom processing
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 …
Ajax-based Post Loading of resources in HTML pages – for reuse of resources and fast user feedback
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 …
Re-assigning Roles to an Owner in Oracle Designer Role Management
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 …
AMIS Query on WebService Security and Administration using the Oracle WebServices Manager – and sneak preview of the Enterprise Service Bus
Service Oriented Architecture is the Architecture Design Pattern of today. Using standard WebService interfaces for functionality published by legacy applications to external consumers, we can easily reuse such functionality …
Generate a native Excel file with SQLX
I wanted to generate an Excel file with data coming from an Oracle database. One of the best ways to do this is to generate an Microsoft Excel XML …
Oracle Raptor – Using Snippets (and adding User Defined Snippets) for quicker SQL and PL/SQL coding
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 …
Oracle releases Raptor – free tool for Database Development (SQL, PL/SQL, database object browsing)
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) …
How Rownum can help you tune a Query
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 …
Example Oracle Designer API script – query and update all Item prompts that end with a colon
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 …
Improve your Web Forms deployment using the Java JDAPI library
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 – Querying a Master for its Details – for example: search Departments with at least one Clerk
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, …
Another VPD challenge with our Oracle Designer generated Web Forms application: No Data Found when synchronizing server derived values
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 …
Oracle Lite Part 2, how to get started (continued)
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 …
Extend the JHeadstart 10.1.2.1 Application Generator to generate optional attribute as required in the client
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 …
Oracle Designer – Script for verifying the privileges assigned to roles against the Module Table Usages
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 …
Have CDM RuleFrame Business Rule Design Transformer generate VALID code
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 …
Oracle 10gR2 – Conditional PL/SQL Compilation
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 …
Violation of VPD Policy on DML raises FRM-40654 :Record Has Been Changed by Another User error in Oracle Forms
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 …
ODTUG 2006 in Washington, DC – Abstracts Due 12 December
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 …
Using .NET Stored Procedures in Oracle 10gR2
From the OTN Series on “Mastering .NET Application Development with Oracle”, this installment on taking advantage of .NET stored procedures in your applications. See Using .NET Stored Procedures in …
Oracle Designer – Keyword Expansion upon Check Out
A little while ago I wrote the article Oracle Designer Check In – synchronize P_VERSION argument on this weblog. In it, I discuss the desirability of having Oracle Designer …
Oracle Designer Report – SQL Script for Roles vs. Modules
On my current project, we had a request from the customer to produce an overview of all the (Database) Roles in the Application with a list of Modules, Screens …
Reporting made easier using XML Publisher
Oracle announces in the November/December issue of Oracle magazine that it will release XML Publisher as a standalone version. This is very good news for all the users that …
Oracle Designer Check In – synchronize P_VERSION argument
As you can probably tell from the topics and nature of my blog-postings recently, I am very deepy involved in a project using classical Oracle development technology such as …
Introducing new Oracle10g R2 features for Application Development (article in Dutch)
For the Fall 2005 issue of OGh Visie, the magazine of the Dutch Oracle User Group, I have written an article introducing the most enticing new features for Application …
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 …
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 …
Designer ERD as pdf
An easy way to get your Designer ERD’s in a PDF-files is using PDFCreator. PDFCreator will install a new virtual printer. Using this printer to print your ERD in …
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 …
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. …
Tuple Rules! Using NVL2 and NULLIF.
While working on a current project I ran into the requirement that a column was mandatory, depending on the value of another column. The other way ’round was also …
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 …