Setting and retrieving CLOB values in Apex

Imagine you have a textarea in your app where you want your users to be able to type in large quantities of text, click a button to store this in the database and then later retrieve this large quantity of text and redisplay it in that textarea.

You can’t do this as you would with other page items (i.e. just submit the page and have the values stored in session state). Any value over (more...)

Passing more than 10 values with apex.server.process

You may be familiar with the apex.server.process function exposed by Apex’s Javascript API. It allows you to asynchronously interact with Apex Application Processes.

A simple example would be.


Apex Application Process

HTP.p(‘You passed “‘||APEX_APPLICATION.g_x01 ||’” as the value for x01. ‘);

HTP.p(‘You passed “‘||APEX_APPLICATION.g_x02 ||’” as the value for x02. ‘);

HTP.p(‘You passed “‘||APEX_APPLICATION.g_x03 ||’” as the value for x03. ‘);



apex.server.process  (more...)

APEX 5.0 Early Adopter has arrived

Suddenly a big thunder rolled through the APEX community -> Version 5.0 has arrived in an early adopter version, as published on Joel Kallmans Blog (as usual on a friday, late night over here in europe).

Over the past 10-15 month we saw numerous presentations of what we can expect in APEX 5, and many of us had our own ideas.

As soon as I got word through twitter I applied for a workspace (more...)

Technical Debt

As a system grows, it accumulates technical debt – improvements and cleanup that your really ought to get around to doing. However, no-one ever budgets time for this kind of refactoring and cleanup.

The consequence is that any major change opens a Pandora’s box of interrelated problems. I’m involved in a project where we thought we could simply make a minor change to all 2768 tables, but due various historical design decisions over the year (more...)

Tools that I use – is service that can monitor if you sites are up and running. I have been using it for more than 3 years and it works very well.
The service is free and you can add up to 50 monitors. It is easy to configure a monitor. You don’t have many options, but it can do just what I need.

You can create 4 types of monitors.

  • http(s): that’s perfect for website monitoring. The (more...)

Free developer day in Perth

Got a massive day of goodies coming to anyone in Perth..for absolutely no cost – just your time and your enthusiasm.

There’s something for

  • database developers
  • Apex developers
  • ADF developers

See you all there …

ORA-65131 grrrr

So…the future is container databases ?

Cool ! I’ll create all my databases as container databases….I’m so happy….until

ERROR at line 1:
ORA-65131: The feature Flashback Data Archive  is not supported in a pluggable database.

It is documented but seriously….that’s not so flash :-)

Tips and tricks for installing and maintaining FMW products

I have written an article for the winter 2014 issue of OTech Magazine.

Unfortunately, something went wrong in the layout process so it does not look too good everywhere, but it is readable.

The site uses some kind of widget to display the magazine. I could not get it working on my iPad and a colleague had problems with IE. If you run into problems, you can download the pdf directly via this link.

The (more...)

desc dba_views does not exist in database open stage

While you issued this dba_*  dictionary views on database mount

SQL> alter database mount;

Database altered.

SQL> desc dba_views;
ORA-04043: object dba_views does not exist

After database opened

SQL> alter database open;

Database altered.

SQL> desc dba_views;
ORA-04043: object dba_views does not exist

Don’t issue this command on database mount stage

Restart the database normal


SQL> alter system flush shared_pool;

System altered.

SQL> desc dba_views;
Name Null? Type
—————————————– ——– —————————-

OWNER (more...)

How do i check versions of *.fmb?


[appltrng@ebsdev ~]$ strings -a /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb | grep Header
FDRCSID(‘$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $’);
$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
FDRCSID(‘$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $’);
$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
[appltrng@ebsdev ~]$ adident Header /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $

Is any email configuration required for Oracle Alert manager?

Yes. If once you email configured on workflow notification mailer, It will automatically send alert mail to you .No need to configure in oracle alert manager mail server options.

So please check it, Whether workflow notification mailer running or not.

Caching in a JEE : don’t write it yourself, use LoadingCache from Google Guava libraries.

Caching data is something you use in almost every JEE project. Most of the time it’s pretty simple : put your data in a .properties file and use a PropertyManager to fetch the data.

But that’s not very flexible and manageable. Updating the values means, updating your property file, repackaging the ear file, and redeploying, and only developers can update the data.

Putting the data in JNDI entries, and using JNDI lookup’s may solve the (more...)

The Twelve Days of NoSQL: Day Twelve: Concluding Remarks

Reblogged from So Many Oracle Manuals, So Little Time: On the twelfth day of Christmas, my true love gave to me Twelve drummers drumming. (Yesterday: Mistakes of the relational camp)(Back to Day One: Disruptive Innovation) The relational camp put productivity, ease-of-use, and logical elegance front and center. However, the mistakes and misconceptions of the relational […]

The Twelve Days of NoSQL: Day Nine: NoSQL Taxonomy

On the ninth day of Christmas, my true love gave to me Nine ladies dancing. NoSQL databases can be classified into the following categories: Key-value stores: The archetype is Amazon Dynamo of which DynamoDB is the commercial successor. Key-value stores basically allow applications to “put” and “get” values but each (more...)

Increase space in Linux Volumegroup while running linux in vmware

If you like to increase space in linux volume group, you can do it on while machine up.

Afer added harddisk on existing hard disk. you can’t identify that hard disk on machine. So in this case you need to rescan the hard disk using below command.

$echo ’1′  > (more...)

Merry Xmas and a project goes live

I hope all my readers have a Merry Xmas and a Happy 2014.

My company has finally delivered an online delivery solution (we are a major food retailer in the UK  for anyone who does not recognise the branding). It is always nice to see a major project go-live and (more...)

When the Oracle wait interface isn’t enough, part 2: understanding measurements.

In my blogpost When the oracle wait interface isn’t enough I showed how a simple asynchronous direct path scan of a table was spending more than 99% of it’s time on CPU, and that perf showed me that 68% (of the total elapsed time) was spent on a spinlock unlock (more...)

Clear memory cache in linux

The below command will remove cache memory

 sudo sh -c “sync; echo 3 > /proc/sys/vm/drop_caches” 




Are younger employees better?

The CEO of a Danish IT company just posted a heretical article (in Danish) where he stated that he preferred younger employees, because they were more productive and more open to new ideas.

Naturally, older IT guys immediately started flaming him. Interestingly, they exactly proved his point: Many older employees (more...)

OpenWorld 2014 Afterparty: The Rock’n’Roll San Jose Half Marathon

Björn Rost and I have appointed the 2014 Rock’n'Roll San Jose Half Marathon to be the  the official OpenWorld 2014 afterparty. It’s Sunday, October 5, 2014 – the Sunday right after Oracle OpenWorld.

Last year, the event was the Santa Cruz triathlon, but this year we’ll go for something (more...)