Creating an XMLType based on Object Types
Sometimes it is necessary to create a Stored Procedure which returns an XMLType, like when you want to expose the Stored Procedure to the “outside world”, like via a …
Category: Oracle
Extreme Decoupling in SQL – Select and DML against a table that is not a table at all
![Extreme Decoupling in SQL – Select and DML against a table that is not a table at all]({"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"} "Extreme Decoupling in SQL – Select and DML against a table that is not a table at all")
One of the key objectives – though not ulterior motives – in Service Oriented Architecture is decoupling. By decoupling currently mutually dependent agents, we introduce more opportunity for flexibility, …
Anti-Search patterns – SQL to look for what is NOT there – Part One
Usually in SQL queries, you will try to retrieve information from a database by reading specific records from the relevant tables. However, there are situations where what you want …
UKOUG Tech – EBS report
December 19, 2010
Oracle, Oracle Application Development Framework, PL/SQL, Software Development, Tools
1 Comment
Just as ODTUG Kaleidoscope and Oracle Open World, the UKOUG Tech-EBS is a great Oracle oriented conference. It’s held in Birmingham but the speakers and participants come from all …
Pipelined Table Functions
I have had trouble with a certain view I have to create at the customer site I am currently working at. The view involves 3 SQL queries combined by …
Masterclass for Java Developers – Make that Database Work for You! 17th December 2010
Really getting the most out of your database. That would be nice, given wat databases can do (and what you may have paid for them). Few serious Java Applications …
Dynamic Actions in APEX
After visiting the OPP/APEXPosed conference in Brussels I decided to write a post on how to create a relatively simple dynamic action in APEX. When you are working with …
PL/SQL (and APEX) highlight of the year: OPP Conference in Brussels, 27-28th October
PL/SQL Developer Tools Session Brussels (Belgium) will be the PL/SQL Hotspot of the world during the two-day OPP 2010 (ODTUG’s Oracle PL/SQL Programming) conference – that is co-located with …
AMIS@OOW
October 7, 2010
AMIS, Data Warehousing & BI, Database, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, XML
No Comments
Yesterday evening we had our annual Oracle Open World review at our office in Nieuwegein. Around eighty people attended and all were very involved with the session. Five AMIS …
Oracle Develop Keynote – Ted Farrell Showing Off ADF in a big big way!
September 22, 2010
Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA
No Comments
A few moments ago, Ted Farrell completed his demonstration of ADF 11g – the premier framework for developing rich, multi-channel applications. In 30 minutes he ran the audience through …
JavaOne 2010 presentation: Why and how to engage a Complex Event Processor from a Java Web Application
Complex Event Processors are capable of handling large volumes of events – by filtering, aggregating or detecting patterns. Java Applications use a CEP to pre-process incoming signals. These applications …
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns (presentation at OOW 2010)
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns – Alex Nuijten and Lucas Jellema PL/SQL is a venerable programming language that is both vital and very …
JavaOne 2010 – Keynote by Thomas Kurian – Java Strategy and Directions
JavaOne started this morning with the first many dozens sessions and the Java Pavilion & Exhibition hall. The official kick off so to speak took place tonight, with Thomas …
Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations
September 21, 2010
Data Warehousing & BI, Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Web HTML5 CSS3
No Comments
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may have used PL/SQL, Reports, Forms, Designer, Portal or the …
SOA Suite 11g Handbook – Chapter Complements
After struggling a bit with various infrastructures that kept falling down (Oracle Wiki, Google Groups) I hope to have found a more stable environment to publish the resources that …
More than five years later – we are finally there: Larry Elison announcing Fusion Applications
September 20, 2010
IT, Java, Oracle, Oracle E-Business Suite, Oracle WebLogic Server, SOA
No Comments
Larry Ellison: We set out to deliver the next generation of business applications. Our task: Take all of the best features from Oracle’s major application products – including E …
Larry Ellison – Opening Keynote of Oracle Open World 2010 – announcing Exalogic, the cloud in a box.
September 20, 2010
Database, Engineered Systems, IT, Java, Oracle, Oracle WebLogic Server, SOA
No Comments
The first major keynote of this year’s Oracle Open World conference was last night – Larry Ellison announcing the Oracle Exalogic machine, the “cloud in a box”. A high …
JavaOne under construction – roads closed down, tent being erected, attendees flying in
San Francisco on the eve of JavaOne 2010. Various preparations are underway in the city. Posters and banners, even on the sidewalks, mark the largest Java show on the …
Oracle Advanced Queuing and JMS – bridging from AQ to JMS and vice versa
September 18, 2010
Database, Databases, Java, Oracle, Oracle WebLogic Server, PL/SQL, SOA
No Comments
In preparation for our Oracle Open World session ‘Xenogenetics for PL/SQ – Infusing with Java Best Practices and Design Patterns’ – I have been doing a little work on …
Event based Decoupling in PL/SQL – your first Advanced Queue adventure
Back in 2004 when we started with the AMIS Technology Blog, my main objective was to record the things I infrequently do in order to have notes describing the …
What questions to get answered at Oracle Open World 2010
The sun is setting in Redwood Shores. The sky is red; the Oracle HQ towers are silhouetted against this dramatic red backdrop. Red, the color San Francisco is about …
What questions to get answered at Java One 2010
It is a very early morning in Redwood City. I am currently in a hotel with a great view on the imposing towers of Oracle’s Head Quarters (although it …
Looking back at ODTUG Kaleidoscope 2010
In case you missed it (how is that possible?) last week was the annual ODTUG conference, Kaleidoscope in Washington DC. In this post I will share some of, what …
Laatste "Plug" – Cuddly Toys Not Included – Een AMIS Query met Doug Burns
June 15, 2010
AMIS, Databases, DBA Oracle, Development Tools, Oracle, Software Development, Tools
2 Comments
Donderdag as. is de AMIS Query van Doug Burns over SQL Tuning, gebruikmakend van de Oracle Enterprise Manager (Tuning en Diagnostics pack). Misschien verwachten velen een hoog “DBA” gehalte, …
Calling an EJB from a SOA Composite Application using the EJB Binding based on Java Interface
I am currently reworking Chapter 12 for the SOA Suite 11g Handbook. This chapter describes various types of interaction SOA Composite Applications can have with Java applications and components. …
Aanmelden AMIS Query "An Evening With…": Doug Burns
Op Donderdag 17 juni, vanaf 18:00 uur, zal Oracle Database Expert en Oracle ACE Director Doug Burns(Schotland), een kennisavond vullen met live demo’s op basis van de Oracle Enterprise …
Aangeboden: ADF 11g Training – 7-11 juni (Nieuwegein)
Van maandag 7 tot en met vrijdag 11 juni verzorgen Luc Bors en Lucas Jellema een 5-daagse ADF 11g training – in het kantoor van AMIS in Nieuwegein. Deze …
ODTUG Preview: mini conferentie (APEX, Database en SOA)
Voor het vierde achtereenvolgende jaar organiseert AMIS de “ODTUG Preview” sessie op 8 juni 2010 bij AMIS in Nieuwegein. ODTUG Kaleidoscope 2010 is een conferentie voor Oracle ontwikkelaars, dit …
Upcoming session by Steven Davelaar on migrating Forms to ADF with JHeadstart 11g
April 27, 2010
AMIS, Development Tools, Oracle, Oracle Application Development Framework, Tools, Web/Java
No Comments
My former collegue and JHeadstart Team member Steven Davelaar will join us at AMIS on wednesday May 19th, at 18:00, to present on a particular feature of the new …
Compliments; Instant productivity improvement for software teams, with a small effort….
Hello, you project manager/team leader. I expected this title to grasp your attention. Would you like to know how to improve the performance of your team members? This can …
Bookreview: Oracle Fusion Developer Guide
April 20, 2010
Development Tools, IT, Java, Oracle, Oracle Application Development Framework, Web/Java
No Comments
Oracle Fusion Developer Guide: Building Rich Internet Applications With Oracle ADF Business Components And Oracle ADF Faces In December 2009 some 750 pages of ADF examples and ADF how-to’s …
Kennissessie ADF 11g – Ode aan de Task Flow
April 20, 2010
AMIS, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
No Comments
ADF 11g staat vooral bekend om zijn rich components waarmee een moderne, interactieve en aantrekkelijke user interface kan worden ontwikkeld. En een beetje om de Data Visualization Components (DVTs) …
Book review of: Getting Started With Oracle SOA Suite 11g R1: A Hands-On Tutorial
Getting Started With Oracle SOA Suite 11g R1: A Hands-On Tutorial Authors: Demed L’Her, Heidi Buelow, Jayaram Kasi, Manas Deb, Prasen Palvankar (aka Oracle Product Management for SOA Suite) …
Oracle VM Single Box Install (Server & Manager/NoVM)
A brother of mine asked me if I could create a database machine and an application server machine during this Easter bank holidays regarding a Demo/Proof Of Concept setup. …
ADF 11g: Debugging Task Flows embedded from ADF Libraries using source code jars
We have been struggling quite a bit with a good approach for modularizing our ADF web applications through the use of (stand alone) Task Flows that are developed in …
Java Callout in Mediator to Automatically Deal With Empty Elements
One of the most annoying things with XML Schema validation is that it will not accept empty elements of certain types, like xsd:date and xsd:double, even though the element …
Hotsos 2010 – A Training Day with Tanel Poder
My last day already, so I hereby leave you with some impressions from Tanel’s Training Day. Maybe until next year. If you also want to learn from him, then …
Hotsos 2010 – Presenters, Presentations, Presenting
I never find it very easy to try to capture the atmosphere during a conference, the presenting part, the presentations or the discussions, for example, you could have with …
Hotsos 2010 – About swag, the Oscars and other stuff
Its Sunday and its raining outside. The nice weather on Saturday (approx. sunny / 20 degrees Celsius) has gone. After a decent flight on Friday where I actually made …
Oracle BPM Studio and Snow Leopard
Business process management (BPM) is getting more momentum. The BPMN 2.0 specification is getting final and has a few new nice features, for example a model standard so that …