Live Handson Environment for Modern Oracle Database Programming
My fellow Oracle ACE Directors and former AMIS-colleagues Patrick Barel and Alex Nuijten have co-authored an impressive book: The book discusses many of the wonders of SQL and PL/SQL …
Tag: plsql
Finally, sftp from an Oracle database using plain plsql
Just a quick blog to get me through the Christmas eve. More than 5 years ago I wrote a blog about FTPS from an Oracle databse. In that blog …
Machine Learning in Oracle Database – Classification of Conference Abstracts based on Text Analysis
Machine Learning is hot. The ability to have an automated system predict, classify, recommend and even decide based on models derived from past experience is quite attractive. And with …
Executing command line scripts from the Oracle Forms client – using WebUtil
Our challenge: we are building the new ERP system – a pure HTML5 browser based application in Oracle ADF. This application replaces the current Oracle Forms based application. For …
The state of the flagship as per Oracle OpenWorld 2016 – Oracle Database 12c Release 2, Exadata Express Cloud Service, SQL and PL/SQL
The new 12cR2 release of Oracle Database had already been announced and discussed at length over the past year. And now it is finally available. And only as cloud …
New PL/SQL pragma (12cR2) to deprecate program units – sign of a modern programming language
Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2. One of the features that stood out was a …
One of the many nice new features in 12c database: code based access control
September 5, 2016
Cyber Security, Databases, Deployment, Oracle, Oracle 12, PL/SQL, Software Development, SQL
1 Comment
Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it. So here’s the story.. For one of our customers …
AMIS25 Beyond the Horizon Conference – Session Resource Repository
Below you will find an overview of all the sessions that took place at the AMIS25 Beyond the Horizon conference (1-3 June 2016, Katwijk, The Netherlands) along with the …
Parse JSON Array in SQL and PL/SQL – turn to a Nested Table
Transferring data between technologies and application tiers is done using various formats – binary, native on the one hand and open, text based such as CSV, XML and JSON …
Reflections after Oracle OpenWorld 2015 – Data Management (Database)
This article gives an overview of some of the most eye catching stories from Oracle OpenWorld 2015 around Data Management. It discusses on premises products such as Oracle Database …
Time is of the essence – The Fourth Dimension in Oracle Database 12c (on Flashback and Temporal Database)
Time has always been an important dimension for data in any database with topics like when was data created, when are records valid, how did records evolve over time, …
Publish a REST service from PL/SQL to handle HTTP POST requests – using the embedded PL/SQL gateway
Oracle Database can act as an HTTP server – using the Embedded PL/SQL Gateway (the 10g successor of the MOD_PLSQL gateway). With just a few statements, we can have …
Invoke a REST service from PL/SQL – make an HTTP POST request using UTL_HTTP in Oracle Database 11g XE
This article is small and simple. It discusses how from PL/SQL an HTTP POST request can be made to a REST service. This particular service is exposed at http://localhost:9002/cinema …
Donderdag 16 april/Thursday April 16th – Speedy Joe’s – Using asynchronous interaction in Java EE to turn the world’s slowest restaurant into a super performant place
De Java SIG (Special Interest Group) van AMIS organiseert op donderdag 16 april een bijeenkomst (publiek toegankelijk) over asynchrone interacties in Java EE (web) applicaties. Synchrone interacties in de …
Set values for bind parameters in a database view using application context – single round-trip context manipulation and querying
While writing an article on database session context for the OTech Magazine’s Spring issue, I tried out whether I can send a SQL statement from a database consumer such …
Everything That Is Really Useful in Oracle Database 12c for Application Developers – Oracle OpenWorld 2014
A few days ago, I presented a session at Oracle OpenWorld 2014 about the most useful features for application developers in Oracle Database 12c (12.1.0.1 and 12.1.0.2). The main …
FTPS with PL/SQL
Doing a FTP-job with PL/SQL is not difficult. A basic implementation of RFC 959 can be written in a few hundred lines. See for instance ORACLE-BASE, How to FTP …
SQL: combine inline PL/SQL function with inline view in Oracle Database 12c SQL Query
Oracle Database 7.3 was the first to support inline views – using the select * from (select * from) syntax. Oracle Database 9i added the with clause for subquery …
Notes from Finland – impressions from the OUGF 2014 Harmony Conference
I am currently attending the OUGF 2014 Harmony Conference in a beautiful setting on a Finnish lakeside. This conference has a great line up in terms of speakers and …
Steven Feuerstein Master Class. Anti-Pattern PL/SQL Programming + 12c New PL/SQL Features, December 12 and 13 2013
12 and 13 December 2013 AMIS will host a two day masterclas with Oracle PL/SQL guru Steven Feuerstein. The Design Pattern movement reminds us that most of the code …
Solving PLS-00753: malformed or corrupted wrapped unit within Apex SQL Workshop
I was working on this great Apex plugin to load Excel sheets with more than 50 columns into the database. And because I had all those great, but secret …
AMIS presenteert: twee-daagse masterclass PL/SQL 12c door Steven Feuerstein
Steven Feuerstein, dé PL/SQL autoriteit, komt op 12 en 13 december naar AMIS in Nieuwegein. Twee dagen lang verzorgt hij een masterclass waar u intensief door hem persoonlijk gecoached …
Oracle Database 12c: PL/SQL package UTL_CALL_STACK for programmatically inspecting the PL/SQL Call Stack
Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK …
Read an Excel xlsx with PL/SQL
At the OTN SQL and PLSQL forum I promised to publish some code I use for a project I’ still working on. This code allows you to select the …
The Very Very Latest in Database Development – slides from the Expertezed presentation
I have just completed my first ever presentation on the Expertezed.com network – http://www.expertezed.com/ , a reprise from my session on Oracle OpenWorld 2012. This presentation includes a number …
The APEX of Business Value… or: the Business Value of APEX? Cloud takes Oracle APEX to new heights!
The attraction of APEX has increased tremendously with the recent launch of the Oracle Cloud. APEX already supported departmental development and deployment of business applications with minimal involvement from …
Kom kennismaken met AMIS en doe mee met uitdagende projecten
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
OOW 2012: The Very Very Latest in Database Development (CON4792)
Database development in the Oracle Database is crucial for creating well balanced multi tier applications. This presentation describes a number of useful facilities and application architecture considerations around the …
Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML
September 12, 2012
AMIS, Database, Databases, Java, Oracle WebLogic Server, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java, XML
No Comments
On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem …
Reduce occurrence of ORA-04068 while upgrading PL/SQL packages by moving global variables to Application Context
This article will argue against the use of (stateful) global PL/SQL variables – as they are both a potential problem for stateless web applications and the availability experienced by …
ADF 11g Business components – Create PL/SQL based entities
While building a (new) ADF 11g application you sometimes have to deal with the fact that you have to use existing PL/SQL procedures for storing your data. This article …
Generating a PDF-document with some plsql: as_pdf_mini => as_pdf3
It has been more than a year since I published my previous blog on generating PDF with pl/sql. In that time I’ve rewritten as_pdf two times, so now its …
Java is niet eng! introductie van Java voor PL/SQL ontwikkelaars – donderdag 5 april
Veel PL/SQL ontwikkelaars hebben (n)iets met Java. Aan de ene kant zien ze dat Java op veel plekken wordt gebruikt, binnen en buiten de Oracle technology stack. En dat …
Jouw toekomst als Oracle professional AMIS informatieavond over jouw ontwikkelingspad (28 februari)
Als je dit leest en je bent Oracle professional – ontwikkelaar of administrator – is de kans groot dat je jouw carriere bent gestart in de jaren ‘90, in …
Jouw toekomst als Oracle professional – AMIS !!EXTRA!! informatieavond over jouw ontwikkelingspad
Als je dit leest en je bent Oracle professional – ontwikkelaar of administrator – is de kans groot dat je jouw carriere bent gestart in de jaren ’90, in …
Publishing to CometD Bayeux Channel from inside the Oracle Database – PL/SQL based push to CometD Web Client
In recent articles, I have introduced CometD as framework for Server to Client and Client to Client Push: Running CometD 2 examples – locally on Tomcat using Maven and …
Absolutely Typical – The whole story on Types and how they power PL/SQL Interoperability (UKOUG, 2011)
This presentation will hopefully convince database developers that types in the Oracle Database are worth their salt – and more. With the recent improvements in 11gR2, the pieces are …
Implementing Web Services backed by a Database PL/SQL API using the Oracle Service Bus
This article accompanies an article on the Architecture section of Oracle Technology Network (OTN): Implementing the Enterprise Service Bus Pattern to Expose Database Backed Services. It provides a detailed …
2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)
October 13, 2011
Announce / Events, Architecture, Big Data, Book reviews and Publications, Cloud, Database, Databases, DBA Oracle, Development Tools, IT, Oracle, Oracle E-Business Suite, PL/SQL, SOA, Software Development, Testing, Tools
No Comments
In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken …
Business Rule: Only One per Day, but keep the time
The business rule states: Only one entry is allowed per ID and per day and the time should be recorded. The table involved (simplified for the blog post) SQL> …