For Lovers only,… of the PL/SQL kind I mean
I just came across this website "I love PL/SQL, and…", one of Steven Feuerstein’s website. If you ever attended a seminar given by Steven, you already know that he …
Category: IT
In between AMIS consultancy jobs…
This (for this site) is a strange post… I am looking for a consultancy job. Nothing new here, but only a strange way to make this visible to the …
Agile software development, the principles. Principle 2: Welcome changing requirements, even late in development.
This is the second of 12 posts about the principles of agile software development. Purpose is to go back to the start of the agile manifesto (http://agilemanifesto.org/principles.html) and discuss …
Used port numbers by the Oracle OEM agent
This is definitly a post worthy as one of the members of the BAAG. The work was extensive (setup, config, install, checking) and afterwards the outcome could have been …
Implementation Restricted Relaxed in Oracle 11g
If you are a regular user of the FORALL statement, you are probably also familiar with this message: PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table …
Maven JMeter plugin and report generation (the last steps to get it working)
August 8, 2007
IT, Java, Software Development, Software Engineering, Tools, Web HTML5 CSS3
9 Comments
JMeter (http://jakarta.apache.org/jmeter/)is a powerful tool for functional and performance testing web applications. JMeter, opposed to selenium, also works perfectly on generated applications (like Oracle ADF ). One of the …
New in Oracle 11g: Read Only Tables
In Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made …
New in Oracle 11g: wait added to lock table syntax
In Oracle 11g you can add a wait clause to the lock table command in which you can specify how many seconds you want to wait to get the …
New in Oracle 11g: the FOLLOWS Clause in Create Trigger Statement
The order in which triggers of the same type fire is arbitrary. But in Oracle 11g the create trigger statement has a FOLLOWS clause. With the FOLLOWS clause you …
Searching the AMIS Weblog directly from your Firefox searchbar
Why bother using Google if you know you will find the answer on this blog anyway? It would be a nice feature if you could search directly from your …
How to execute a search by pressing the ENTER key in UIX
July 27, 2007
Development Tools, IT, Java, Oracle Application Development Framework, Web/Java
2 Comments
Many end users are used to pressing enter after inserting one or more search terms in an HTML form. Many, if not most, online search engines support this. Unfortunately, …
Demonstration of the ADF Faces Matrix Component
This article will demonstrate some of the capabilities of the ADF Faces Matrix Component I have been working on for last few weeks. It is a fairly generic component …
JSF EL Calculator bean – to overcome coercion errors and add functionality to EL Expressions
In a recent project I was working on JSF page that needed to display the result of a calculation performed on values taken from various bean properties. The beans …
Oracle 11G: describing a refcursor
![Oracle 11G: describing a refcursor]({"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"} "Oracle 11G: describing a refcursor")
In Oracle 11G the supplied package DBMS_SQL is extended with two new procedures: to_cursor_number, which transfers a refcursor to a "dbms_sql cursor" to_refcursor, which transfers a "dbms_sql cursor" to …
Puzzelen met SQL – De Ideale Televisieavond van Madelon
Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in Nederland. In dit on-line artikel kunnen …
How to test for DBMS_OUTPUT with Quest Code Tester
What is the most common way of testing PL/SQL code? I think it is using DBMS_OUTPUT and manually verifying the results. Is it the best way of testing code? …
Uploading CSV files into dynamic ADF Faces tables – programmtically creating columns
July 15, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
4 Comments
In a recent article – ADF Faces File Uploading – It is really that simple! – I described how to set up file uploading with ADF Faces. Using the …
ADF Faces File Uploading – It is really that simple!
July 14, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
26 Comments
One particularly type of interaction in web applications is typically a little bit tricky. Requiring additional analysis of the frameworks used. For me personally it was even the way …
Oracle 11G: XMLQuery = eval
A nice little trick on Oracle 11G is using XMLQuery as an eval function: SQL>l  1 select substr( sys_connect_by_path( level, '*' ), 2 ) || ' = ' …
New PL/SQL Compiler Warning in Oracle 11g
The PL/SQL compiler in Oracle 11g will give you a warning if it encounters a when others exception without a raise or raise_application_error. SQL> alter session set plsql_warnings='enable:all'; Session …
Building a report in XML Publisher
Last week I made my first steps with XML-Publisher 5.6 Desktop and I am very pleased with the simplicity you can create a report in such a short time. When …
New PL/SQL Feature in Oracle 11g: the use of sequence.nextval
Another small new feature in Oracle 11g PL/SQL: you can directly use sequence.nextval (and sequence.currval). It is not necessary anymore to do something like select sequence.nextval into l_seq from …
Sharing only the APPL_TOP in 11.5.10
In the past days I have implemented a well known architecture to many of my fellow Oracle E-Business Suite DBAs: An architecture that consists of multiple Application Servers. Until …
ADF goes Google – Implementing a Global Search facility in ADF Applications (private)
July 12, 2007
IT, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
1 Comment
An interesting requirement for a freshly started ADF project: a Global Search widget, available on virtually every page, that allows the user to enter a search string and perform …
The four major Java IDEs: Eclipse, NetBeans, IntelliJ IDEA and JDeveloper
An interesting article was recently published on The Server Side: It discusses a shootout in Cologne between Java IDEs: Eclipse, NetBeans, IntelliJ and JDeveloper. While the author – …
JavaScript Issue with Maximizing the Window – onLoad comes too soon, use setTimeOut for delayed execution
Today a small matter that took quite a lot of time. In my ADF Faces application, a command button brings up a dialog window (browser pop up window). My …
ADF Faces – Client Side Column Hide and Seek – Expanding/Collapsing Columns in Table
Tables are probably the most important ADF Faces component to present data to the end user. A table can present a huge amount of data at once, both in …
EclipseLink – Youngest Open Source Project provides venerable Java Software – TopLink’s enterprise level Object Relational and Object XML mapping now open source
Some months ago, Oracle announced its plans to donate the high end Object Relational Mapping Framework TopLink to the open source community. To be more specific: under the EclipseLink …
ADF Faces – Server Side (partial page rendering) Column Hide and Seek – Expanding/Collapsing Columns in Table
Tables are probably the most important ADF Faces component to present data to the end user. A table can present a huge amount of data at once, both in …
ADF Faces – Nested Columns
Recently I ran into a requirement on an ADF project to present columns in an ADF Faces table component in a clustered (nested) fashion. Out of 12 columns, one …
ADF – Context specific filter in List of Values – (only list employees previously allocated on other project for this customer)
July 7, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
No Comments
Another tale from the ADF (10.1.3.2) project for the Interior Decorator chain of stores. When the sales representative is creating the decoration plan for a home or office building, …
My rediscovery of vi
I am sure I am one of those humans that are using something for a long long time, and suddenly find out they have been doing things in a …
Generic JavaScript functions for generic DOM exploration – leveraging the JavaScript dyamic function creation
Often there is a need for client side (JavaScript) DOM oriented manipulation in Web Applications. To achieve a higher degree of user interactivity, more productivity or simply a more …
Calling a PL/SQL Function at the wrong time gets me into trouble – the dreaded ORA-0113 End of Comunication Channel with a hierarchical query
I have a query: an in line view, built from two simple queries unioned together, that forms the starting point for a hierarchical (connect by) query. Nothing up my …
Automatically return nested records from ADF List of Values – for example allocate all subordinates on project along with manager
July 2, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
1 Comment
In a previous post I was telling you about an ADF project we are discussing for a chain of interior decorating shops. One challenge we encountered in the functional …
Mutually dependent dropdown lists in ADF Faces – leveraging ADF BC Bind Parameters and ADF Faces Partial Page Rendering
July 1, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
3 Comments
This week we were having a session in which we had to estimate the effort required for a new ADF project. The application we have to develop will support …
MyFaces Trinidad – using AJAX (PPR) for Row and Column Summaries in Tables
The built in Partial Page Rendering mechanism in Apache MyFaces Trinidad helps us implement AJAX-style features such as immediate calculation/derivation, validation, and conversion as well hide/display page element and …
JDeveloper 10.1.3.3 Patch Release available on OTN
As of yesterday, the JDeveloper 10.1.3.3 release is available for download on OTN: http://www.oracle.com/technology/software/products/jdev/htdocs/soft10133.html. Apparently, this release is only a patch release with bugfixes (see http://www.oracle.com/technology/products/jdev/htdocs/10.1.3.3/fixlist.htm for an overview …
ODTUG Kaleidoscope: HOTSOS Instrumentation Library for Oracle
Last week six of us at AMIS attended the ODTUG Kaleidoscope conference in Daytona Beach, FL. I always need some time to digest all the information that was presented …
Long expected patch for SOA Suite available
The long expected patch set to upgrade the SOA Suite 10.1.3.1 to 10.1.3.3 is available on metalink (patchnr. 6148874).