//AMIS Technology Blog » apex » Page 2

Posts tagged apex

SIG Event

OOW 2011 – What's New, Improved and Coming in Oracle Application Development

0

Currently at Tom Kyte’s session regarding topics new, improved or coming in Oracle Application Development. Tom told about the history APEX has gone thru and the current setup with the APEX Listener and even the “PL/SQL Gateway” was mentioned. I always have to laugh a bit because this last one touches the XDB Protocol Server which can do way more then only this PL/SQL extension for APEX which has been embedded in this XDB Protocol Server framework. There is a APEX book out there that touches a bit the possibilities of the framework, one of the reasons I will promote and explain it a bit more during conferences like UKOUG, because I think its a shame that people don’t know its full potential. Anyway. Tom stressed once again that APEX is a serious environment regarding the huge websites out there based on APEX supporting 1000th of user sessions. Also it nowadays had a better debug support (4.1) and use / support for ROWID, improved data upload and calendar wizard support and redesigned websheets in APEX 4.1.

(more…)

Vacatures bij AMIS services

Leveraging APEX in XE 11gR2 to rapidly load Excel data into a database table

1

Whilst preparing for the Thursday Thunder session at the last day of the ODTUG Kaleidoscope 2011 conference in Long Beach, where an all star team of moderators and developers will present a live application development session with key components from Fusion Middleware, I came across a very useful feature of APEX, readily available in my local light weight Oracle XE Database 11gR2.

The Thursday Thunder session will create a portal for participants of a technology conference just like ODTUG Kaleidoscope itself. It will also create a back office application for the conference’s organizing team and it will model and implement a key business process addressing the submission, acceptance and delivery of presentations at the conference. This session has three moderators – Chris Muir, Lonneke Dikmans and Duncan Mills – and a development team of five – Edwin Biemond, Peter Ebell, Ronald van Luttikhuizen, Luc Bors and Steven Davelaar. In order to have a case that is as realistic as possible, I requested the ODTUG organizers for the actual data of this year’s conference – in terms of presenters, sessions and the planning of them all.

They were very helpful and almost instantly provided me More >

Vacatures bij AMIS services

XFILES APEX Community Edition (XACE)

0

Roel Hartman and me are currently very busy with our Kaleidoscope 2011 presentation “XFiles, the APEX Version: The Truth is in There…“. During this presentation, we will demonstrate the awesome possibilities you can create when you combine the APEX and XMLDB functionality of the APEX database environment. And as you probably also know, two “no cost options” delivered with your Oracle database. Our first presentation/demo will be on the AMIS Kaleidoscope Preview Sessions on the 14th of June, to test our “setup” and combined presentation for the real thing during Kaleidoscope, in Long Beach, USA, this year.

Background

The demo will demonstrate how to setup database build-in versioning capabilities, based on standard XMLDB functionality, that can be used by or for APEX applications, while making use of the file/folder metaphor of the XDB Repository.

(more…)

SIG Event

Getting started with your career (in Dutch)

Als bezoeker van deze blog ben je bezig met het maken van mooie oplossingen en nieuwe uitdagingen op technisch gebied. AMIS nodigt je uit om ons team te komen versterken. AMIS wil je op het gebied van Oracle en Java uitdagen de volgende stap in je carriƫre nemen.

AMIS merkt al enige maanden dat de markt voor Oracle en Java opdrachten aan het aantrekken is en maakt dat concreet met het uitvoeren van innovatieve opdrachten.

Om je een beeld te geven van het werk bij AMIS volgt hieronder een lijst met de trajecten waar we de afgelopen maanden aan gewerkt hebben.

  • OSB / SOA Suite implementatie bij een grote informatieverwerkende organisatie.
  • Realisatie in ADF 11g van een backend applicatie voor een internetwinkel.
  • Realisatie van een SAAS oplossing op basis van Hibernate, Seam en RichFaces.
  • Realisatie van een medisch registratiesysteem in ADF.
  • Advies op het gebied van het gebruik van ADF 11g in combinatie met JHeadstart voor een energiebedrijf.
  • Realisatie van een SOA / BPEL implementatie voor een pensioenfonds.
  • Realisatie van een administratiesysteem voor een verzekeraar buiten Nederland (EU) in ADF 11g en JHeadstart.
  • Oracle XML DB implementatie voor een grote bank.
  • Realisatie van een More >
Vacatures bij AMIS services

APEX plugins contributed to the APEX community by AMIS developers

1

I have to admit that, even though I have tried on several occasions to dive head first into APEX, so far I have only wet my feet. I have played a little with APEX 4.0, liked the development experience [a lot better at least than the 3.x world] and found that many concepts are the same, whether your do APEX, ADF or [presumably] .NET web application development.

One of the nice features in APEX 4.0, that allows for more more organized, better structured development with lots more reuse potential, is the plugin framework. Through this framework, interesting and reusable pieces of functionality can be shared within and across applications – as well as across the APEX developer’s community. And that community is something to be reckoned with with many, many developers around the world.

Some very enthusiastic and quite active members of the APEX community work at AMIS. And they have produced a number of plugins, and shared several on the Plugin Directory: http://www.apex-plugin.com/index.php.

(more…)

SIG Event

APEX: Creating a form based on a procedure

3

Introduction Within ApEx for a while it has been possible to create a page (more specifically, a form) based on a procedure. A procedure enables you to build in more logic than a simple DML statement or otherwise. My example is relatively simple in that when I want to book an appointment with somebody, I do not want this appointment to overlap with somebody else’s. Maybe I even don’t want my appointment to be directly after or before another one, and want a 15 minute break.

Scenario

Build the procedure This kind of scenario is not easy to realise if you don’t have a plan. The plan is therefore to build an INSERT statement (into a procedure, not a function!) that is only actually executed when there is enough room for my new appointment – in terms of time – in my agenda. Building this procedure is done in the Object Browser area of Apex (Home –> SQL Workshop –> Object Browser; press Create). To check that there are actually no overlaps you need to know when the appointment starts and how long it will take. (Loads more additional features could be added, I am trying to keep the example simple for now). This justifies at least 2 IN-parameters for a procedure to be built, starting More >

Go to Top