Weblog for the AMIS Technology corner
Jurgen Kemmelings
This user hasn't shared any biographical information
Posts by Jurgen Kemmelings
The Inbound File Adapter – Use trigger file
22/12/2010 - 4:27 pm
Posted in SOA & Oracle Fusion Middleware | 2 comments
The Inbound File Adapter can be used for polling and processing new files in a specified directory. With the Adapter Configuration Wizard you can create this File Adapter Service quite easily. Especially if you follow an example! In step 7 of the wizard I decided to deviate from my example and checked the ‘Use trigger [...]
New in Oracle 11g: Read Only Tables
7/8/2007 - 12:42 am
Posted in Database, General, Oracle | 3 comments
In Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made read only to other users, by granting only the select privilege to these users. But the owner of the table was always able to do updates [...]
New in Oracle 11g: wait added to lock table syntax
2/8/2007 - 1:21 pm
Posted in General | No comments
In Oracle 11g you can add a wait clause to the lock table command in which you can specify how many seconds you want to wait to get the lock on the table.
SQL> lock table t in exclusive mode wait 10;
lock table t in exclusive mode wait 10
*ERROR at line 1:ORA-00054: resource busy and acquire [...]
New in Oracle 11g: PL/SQL Function Result Cache
31/7/2007 - 10:53 am
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 5 comments
A new feature in the Oracle 11g database is the ‘Function Result Cache’. When you create a function with the new clause ‘RESULT_CACHE’ the result of the function is stored in the cache for each parameter value it is called with. When the function is called again with the same parameter the result is retrieved [...]
New in Oracle 11g: the FOLLOWS Clause in Create Trigger Statement
The order in which triggers of the same type fire is arbitrary. But in Oracle 11g the create trigger statement has a FOLLOWS clause. With the FOLLOWS clause you can specify after which other trigger of the same type the trigger should fire. For example, if you have two triggers, testa and testb, on table [...]
New PL/SQL Compiler Warning in Oracle 11g
14/7/2007 - 3:44 pm
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 1 comment
The PL/SQL compiler in Oracle 11g will give you a warning if it encounters a when others exception without a raise or raise_application_error.
SQL> alter session set plsql_warnings=’enable:all’;
Session altered.
SQL> create or replace procedure testje as
2 begin
3 dbms_output.put_line(‘why do something?’);
4 exception
5 when others
6 then
7 [...]
New PL/SQL Feature in Oracle 11g: the use of sequence.nextval
13/7/2007 - 11:00 am
Posted in General | 4 comments
Another small new feature in Oracle 11g PL/SQL: you can directly use sequence.nextval (and sequence.currval). It is not necessary anymore to do something like select sequence.nextval into l_seq from dual in your PL/SQL block. A small example:
declare
l_seq number;
begin
l_seq := oe.orders_seq.nextval;
dbms_output.put_line(‘Value of orders_seq.nextval = ‘||to_char(l_seq));
end;
SQL>
Value of orders_seq.nextval = 1000
PL/SQL-procedure is [...]
New PL/SQL Feature in Oracle 11g: CONTINUE
12/7/2007 - 8:03 am
Posted in Database, Devel. + PL/SQL tools, General, Oracle | 4 comments
A minor new PL/SQL feature in Oracle 11g is the new statement ‘continue’. With the continue statement you can skip to the next iteration in a loop. A small example:
begin
for i in 1..3
loop
dbms_output.put_line(‘i=’||to_char(i));
if ( i = 2 )
then
[...]
Using unique function based index as check constraint
14/7/2006 - 11:02 am
Posted in Devel. + PL/SQL tools | 3 comments
Case: In a table there is a column customer_code and a column status. The allowable values of status are I, P, C, E. The status indicates that a record is just inserted (I), in process (P), completed (C) or in error (E). The constraint that has to be implemented: the combination of customer_code and (status [...]
AskTom Live with Tom Kyte! – day two
A short report of the second day of the OakTable Seminar AskTom Live with Tom Kyte!
The day started with the last part about analytic functions that we didn’t finish yesterday. Analytic functions are so ‘brutally great’ that it is all very much worthwhile. It appears that once you have learned to use them you will [...]
