Ant, Stored Procedures and dbms_output
Running sql (scripts) from ant using the ant task is quite easy and straight forward. Unfortunately, the ant sql task is not really suited for running pl/sql, e.g. exec …
Category: Oracle
Oracle Rules… the world?? Design and Run-time Rules Engine – also for PL/SQL?
I was triggered by the news item on OC4J on OTN’s homepage, ” Download Oracle Application Server 10g (10.1.3) Developer Preview 4 – including … Oracle Rules” to resume …
Oracle Warehouse Builder – 10gR2 Paris release – Even if you do not build warehouses…
AMIS is participating in the Oracle Warehouse Builder Paris Release Beta program. Unfortunately I have not had too much time for in depth involvement myself. However, from what I …
PLDOC, documenting your PL/SQL directly from the database
![PLDOC, documenting your PL/SQL directly from the database]({"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"} "PLDOC, documenting your PL/SQL directly from the database")
Ever asked a PL/SQL code developer to create documentation for his code, the way Javadoc is able to create for Java code? It is possible using the open-source tool …
New HTML Form element: Radio Select – Combining Radio Button and Select items
It has always been a bit of a tricky discussion, when to use a group of Radio Buttons and when to use a Select (List) in an HTML Form. …
Feuerstein is coming to Amsterdam
On september 8, 2005 Quest Software will organize a training seminar in Amsterdam by Steven Feuerstein. It will cover two topics: 1. Correcting PL/SQL Worst Practices and 2. Survey …
Running UltraSearch
Oracle UltraSearch is a web-based search application based on Oracle Text. It can be used to index a wide variety of datasources like websites, databases, files etc. and to …
Using Oracle Enterprise Search (Text Searches)
Last week I attended a Theme meeting of the Dutch Oracle Usergroup (OGH). The topic was called “Zoek en Gij zult Vinden” (“Search and you will find”) by Wouter …
Oracle High Availability Concepts
Audience: DBA’s, infrastructure architects. A brief explanation of the Oracle Dataguard and High Availability concepts.
Oracle text
The Dutch Oracle Usergroup (OgH) organized a session about (text) searching capabilities of Oracle technology. The presentation was done by Wouter van de Weghe of Oracle and consisted of …
Oracle Enterprise Manager
With Oracle 10g (release 1) the enterprise manager is only available as a web-based application. However, it doesn’t provide all the necessary options yet. Among others, the xmldb and …
DB utilities – splitting generated DDL scripts
Have you ever tried to split the DDL scripts generated by Designer? Pretty tough, isn’t it? Well, I have a nice solution for you: the Perl script sql_split.pl splits …
SuSE 9.3 Linux available for free
Since last week the new SuSE Linux Professional version 9.3 is available for download. You can download it from a mirror in your vicinity and install it via FTP.
Oracle Database 10g Release 2 available (only on Linux right now)
Oracle just released (or at least I just saw) the availability of the Oracle 10gR2 database, for Linux. I assume that in a few days time we will also …
ODTUG 2005 Wrap Up part 3 – The position of JHeadstart and The Magnifying Glass gadget for presenters
It was over more than a week ago. But I am still processing all I have heard and seen at ODTUG 2005, the Oracle Development Tools User Group conference …
Workshop ADF Binding Framework – Creating a programmatic ADF Client and Developing a WebService front end using Oracle ADF
With last week’s workshop on the ADF Binding Framework (with 13 AMIS Java developers) and next week’s three day workshop on JHeadstart and the Knowledge Center session on Oracle …
AMIS Knowledge Center Session on Spring Framework
Yesterday (Thursday) we had our six-weekly get-to-together for the Web & Java Knowledge Center. This time the focus was the Spring Framework. Aino and Lucas presented on their findings …
Oracle Fusion
As the world is moving to Service Oriented Architectures (SOA) companies are rebranding and consolidating their products into a complete, supportive and integrated platform. That’s where Oracle Fusion Middleware …
ADF Faces – The Next Really Big thing from Oracle Development (ODTUG Wrap Up – Part II)
One of the important threads through the entire ODTUG 2005 Conference last week was the future of JDeveloper and Oracle’s position in the Java/J2EE Arena in general. It turns …
About nulls in the database
The july/august edition of Oracle Magazine has a very interesting article by Lex de Haan and Jonathan Gennick about Nulls (‘nothing to worry about’) in the database. Although I …
JDeveloper for free
The rumours were right: JDeveloper will be available for free. However, ADF and OC4J still need to be licenced (for use in a production environment). Read the discussion on …
Linking a button to an LOV page in ADF UIX
Imagine this situation: in an input form you need to be able to pass a value from one of several LOVs to the same text field. Using JHeadstart, it’s …
Passing on a session variable to the BC layer in ADF
In one of our projects we ran into this next problem. We had a ViewObject with attributes representing several columns from two tables. Depending on whether or not the …
Oracle's Forms Strategy – Does it exist? ODTUG 2005 Wrap Up (part 1)
I do not understand Oracle’s strategy with regard to Oracle Forms. If such a thing really exists. Oracle has made it very clear that Development Tools are only considered …
Oracle Database 10g Release 2 – SQL and PL/SQL Features
Arup Nanda writes about new features for the upcoming Oracle 10gR2 release, targeted at the end of June 2005. In this article, he discussues new SQL and PL/SQL features. …
ODTUG Day 3 – Quiz on SQL and PL/SQL
Today Alex and I did our “Oracle Quiz on SQL and PL/SQL Quiz – See Water Burning” presentation. We wanted to demonstrate a number of new and old features …
Day Two of the ODTUG 2005 Conference – Oracle's Development Tools Strategy, JDeveloper free?, JHeadstart and more…
ODTUG 2005 is under way. 600 Oracle Developers, users of Oracle Forms and Designer, JDeveloper and Portal, Discoverer and Reports and many other Oracle technologies, have gathered in the …
Day One of the ODTUG 2005 Conference – first impressions and my first presentation: 10g Top 3 SQL and PL/SQL
The show is back in town, and so am I. Precisely one year a go, the ODTUG crowd assembled in Scottsdale, Arizona. This year we all flocked to New …
Pulling the rug from under your feet while keeping standing – Using the Hot Swappable Target Source in Spring AOP
Spring AOP offers a wealth of new options in programming as well as designing Java applications. A somewhat more advanced feature is the Hot Swappable Target Source. The concept …
Getting into Spring AOP – Implementing simple business logic on top of Domain Objects using Aspect Oriented Programming
Aspect Oriented Programming is one of the hypes in Java programming. Through AOP, we can program the functionality for a Class in more ways than just by writing the …
Jumpstart Spring
Since Lucas already gave an in-depth review of the Spring workshop, I’ll take the breadcrumbs ;-( After some years of Java/j2ee developing Spring comes for me at the right …
How to call methods from EL expressions- pre JSP 2.0 trick for JSPs with JSTL
I finally got round to describing a trick that I have implemented more than one year ago. It happened to come up during last week’s Spring workshop, so I …
Spring Workshop – Day Four – Rod and Alef on AOP, JMX and Remoting (Spring does EJB??)
Friday I attended the last day of the Spring Workshop. An interesting menu for today’s dinner: Aspect Oriented Programming, JMX support and Remoting. Friday, the last day of the …
My First AJAX – the simplest Asynchronuous JavaScript Server call man can imagine
Inspired by Aino’s post AJAX and RIA, I wanted to get my first XMLHttpRequest object based AJAX example getting up and running. It is a standalone HTML page that …
Who is calling me? – Analyzing the Java Callstack
During the Spring Workshop, Rod Johnson started a brief discussion on how to find out in a Java Class who invoked the method currently being executed. The best trick: …
Ajax and Ria
Despite of what the title may suggest this is not about a greek mythological drama about a hero and a woman. But it Ãs about interaction and exchanging of …
Struts-Layout tag library 1.1 released
Quoting straight from The Server Side: Struts-Layout is a tag library for Struts which provides skinnable tags that display panels, input fields, form modes,tables, pagers, treeviews, sortable lists, popups, …
Day 3 of the Spring Workshop – On Persistence and Transactions and ever more Test Driven Development
Rod Johnson took over from Alef again to talk about the Spring DAO module, Spring’s support for leading persistence frameworks. Spring takes over a lot of configuration details for …
Spring MVC – move over Struts? Day two of the Spring Workshop
Today I attended the second day of the Spring Workshop by Rod Johnson and Alef Arendsen, two of the core team of the Spring Framework. Having been thoroughly lectured …
Power to the POJO – day one of the Spring Core Committer's workshop
If there is one wave (or hype if you like) flooding the Java/J2EE arena right now – well, there is JSF and EJB 3.0 and AJAX and Java 5 …