….is that when you really need to, it allows you to turn up your applications instrumentation to 11. A 30 second PL/SQL Conditional Compilation overview PL/SQL Conditional compilation was introduced with Oracle Database 10gR2. The official documentation explains how to use the Conditional Compilation constructs but doesn’t give too many use cases. Fortunately the Oracle White Paper […]
The PL/SQL Compiler warning “PLW-06009: procedure “string” OTHERS handler does not end in RAISE or RAISE_APPLICATION_ERROR” was introduced with 11g release 1. It’s purpose is to alert you to the fact that you have a WHEN OTHERS exception handler and the last statement within it doesn’t contain a RAISE or a RAISE_APPLICATION_ERROR statement. The first example […]
Introduction As an exceptional Oracle Developer you already know the value of instrumenting your code. You have read enough of Tom Kyte, Cary Millsap & Steve McConnell to understand that with the correct instrumentation diagnosing problems especially time critical problems (are there any others?) becomes much easier. So the question is not why you should instrument your […]
…is simply to go here and create an account. This will get you up and running with Application Express without even leaving your browser.
The ability of using SQL to operate on Associative Arrays or PL/SQL tables as they were known when I started working as a Database Developer is one of my favourite new features of 12c. I wasn’t aware of it until I read the post by Connor Mcdonald. It’s announcement within the new features guide is […]
iancarpenter.dev 
You must be logged in to post a comment.