tag:blogger.com,1999:blog-180370242012-01-27T14:24:43.499+01:00Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog.Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger3321100tag:blogger.com,1999:blog-18037024.post-15710695987482392942012-01-24T08:51:00.000+01:002012-01-24T08:51:41.628+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Recently I've spent more time than necessary in comparing identical objects in two oracle schemas, because SQLDeveloper's "Database Diff" tool doesn't offer the option to ignore whitespace. For some reason there were objects with an extra trailing newline character beyond the end of

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-80369372347237886672012-01-19T23:11:00.000+01:002012-01-19T23:11:16.127+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. A quick tip for formatting years when they show up as labels in flash charts inside Oracle Application Express (Apex). The problem is in that Anychart is too smart, so when it encounters a label that looks like a number, it will format it with the separator for the thousands, i.e. "2012"

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-16357965525148452482011-12-21T11:07:00.000+01:002011-12-21T11:07:06.630+01:00

In case you missed it, the latest SQL Developer Early Adopter 3 release is available for download since yesterday.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-6712361316138923252011-12-13T14:43:00.001+01:002011-12-14T10:12:19.153+01:00

I remember an old article in the HP Journal, must be in the early '90s, where some engineer explained how to make music out of the stepper motor built into an HP Scanner by sending commands over the SCSI interface, so this must be the outcome of many hours of hard work :-) Enjoy.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-38832395062084768592011-12-05T09:49:00.000+01:002011-12-05T09:49:36.719+01:00

Coalition of top tech and media companies to make internet better place for our kids I can imagine how people will feel reassured after knowing that Berlusconi's foremost company want's to make Internet a better place for kids (in cooperation with other top companies not really famous for their achievements in privacy management). There is nothing better than a good laugh to start a week.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-50942879906891935742011-11-29T22:31:00.002+01:002011-11-30T09:03:01.835+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. I made a cursory search for a list of bugs present in Oracle Application Express 4.0.1 or 4.0.2 and fixed in 4.1, but I could not locate this little bug. Here it is: say you need to copy page 1 to page 3. Apex will duly search and replace the occurrence of the various forms of page

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com4tag:blogger.com,1999:blog-18037024.post-75591835250769841302011-11-24T17:38:00.002+01:002011-11-24T17:39:27.267+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. This error is caused by a nice Oracle documentation typo: the enumerated constant StatelessWithFastRestPackageState is misspelled in table 37-19 (in both 10.2 and 11.1 DBMS_EPG chapters of PL/SQL Packages and Types Reference), but is correctly reported elsewhere (too bad I read the

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-18251312854740720472011-11-16T11:54:00.000+01:002011-11-16T11:54:42.189+01:00

In case you missed it, the SQL Developer 3.1 Early Adopter Release 2 has been made available for download last night. The good news for me is in that it seems they have fixed a very annoying problem that caused SQL Developer to hang when you restarted the application after closing it on Mac OS X.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com3tag:blogger.com,1999:blog-18037024.post-51438085705870118922011-11-07T22:42:00.029+01:002011-11-07T22:51:50.127+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. It's not the first time I write about ORA-19025, however I believe that what follows is an interesting and not so common situation. Imagine you receive an XML file that have been working perfectly for 3 years and suddenly it throws out the infamous exception: ORA-19025: EXTRACTVALUE

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-27707931075150195802011-11-04T16:18:00.002+01:002011-11-04T16:19:47.796+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. My first close encounter with the brand new Oracle XE11 returned the following error upon importing a dump that a customer sent me for preparing a demo. ORA-39097: Data Pump job encountered unexpected error -30094 ORA-39065: unexpected master process exception in DISPATCH ORA-30094:

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-87421577254053351452011-09-08T09:43:00.002+02:002011-09-08T09:51:19.952+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Here is a classical situation where I don't know if I am staring at a bug, at a feature or I am simply drunk. I am executing DBMS_METADATA.GET_DDL in an Oracle XE (10g) instance, in order to get the DDL for the table constraint as an ALTER statement, but the function throws a weird

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-78228890084562260432011-09-01T18:32:00.000+02:002011-09-01T18:32:34.716+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Ever tried to run UTL_HTTP.BEGIN_REQUEST procedure passing an URL that points to a HTTPS (SSL) server? That's what happend to me recently as some procedures that have been working for nearly two years without a hitch suddenly stopped working. After reviewing my app logs it turned out

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-4768305368352725212011-08-24T22:18:00.000+02:002011-08-24T22:18:14.932+02:00

Apex 4.1 has been released. For more details see the latest posting of Joel Kallman. Enjoy

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-63540820231212872472011-07-09T19:37:00.000+02:002011-07-09T19:37:24.904+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Ever encountered the following error when attempting to delete one or more rows in a tabular form report? ORA-20001: Error in multi row delete operation: row = nnn, ORA-1403, no data found. Error in multi row operation failed If yes, it means you've been too adventurous and probably

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com3tag:blogger.com,1999:blog-18037024.post-64149044843236105172011-06-13T12:54:00.000+02:002011-06-13T12:54:42.990+02:00

Reinstalling or restoring the operating system to a previous state in Mac OS X is definitely something you don't need to perform often, however it seems that the time has finally arrived. As I have a few machines in different locations, I wondered how I could create a backup copy of the original Snow Leopard installation disk in order to keep my original disk in a safe place. Copying DVDs can be

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com6tag:blogger.com,1999:blog-18037024.post-33387138578255409702011-05-19T16:45:00.001+02:002011-05-19T16:45:00.649+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. If you are getting ORA-31608 when attemping to display the DDL for a table in SQL Developer 3.0, 2.1 and probably earlier, you should make sure that the table is not a materialized view. ORA-31608: specified object of type INDEX not found ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-91670868231244481582011-05-06T23:59:00.000+02:002011-05-06T23:59:59.017+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. As my friend Joel Kallman disclosed a couple of hours ago, Oracle Application Express Early Adopter release 1 is available for testing at http://tryapexnow.com. I recommend checking out the What's new first to quickly skim through the most recent additions to this outstanding tool.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-82690683819170448072011-04-21T16:20:00.001+02:002011-04-21T21:29:44.246+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Since 10.30 CET all Amazon EC2 instances located in the US-EAST region are basically unreachable or unusable.As i have several web apps running over there, this is a problem for me.It's a pity because I'm (still) really enthusiastic about the possibilities offered by an infrastructure like

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-15179048141415877232011-04-01T22:19:00.003+02:002011-04-01T22:25:07.568+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.With some sense of humor, Oracle released on the first of April the much awaited beta version of Oracle XE 11G, so more than one initially thought it was a prank.Well, it's not, but i didn't install it yet, so there is still room for surprises... ;-)

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-9111020701793859882011-03-29T21:31:00.002+02:002011-03-29T21:42:57.668+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.SQL Developer 3.0 has been officially released today.For the details about new features and improvements, the release notes are a good starting point.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-73944165298666819232011-03-16T17:30:00.001+01:002011-03-16T17:39:02.617+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This is just a little reminder in case I forget (again) that the SMTP port on Amazon EC2 receives special attention due to the potential exploitation by spammers.If you run multiple Apex instances on Amazon EC2, it may sound convenient to configure a single mail server for all instances.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-89241587892192986462011-03-01T15:44:00.003+01:002011-03-01T16:42:44.328+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This is a very funny error code, especially when you get it while processing someone else's XML documents.I had to read the message three or four times before I finally figured out what the real problem was, however I won't bother you with my own problems, so let's go straight to the core

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-35668530291253746552011-02-16T12:15:00.005+01:002011-02-16T17:42:14.214+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you host multiple web sites on the same apex server (using Apache as proxy and EPG) and some of these applications display flash charts, you might incur in the annoying problem of the security warning:Flash Security Error:AnyChart can not be launched due to Flash Security Settings

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com8tag:blogger.com,1999:blog-18037024.post-29159850844321694442011-02-10T17:25:00.001+01:002011-02-10T17:26:09.885+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you are wondering why after exporting with EXPDP a schema from an Oracle Enterprise Edition 11gR2 database and importing it on an Oracle Standard Editon 11gR2 you are getting errors like:ORA-00439: feature not enabled: Deferred Segment Creationthen you must know you have just hit one of

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com3tag:blogger.com,1999:blog-18037024.post-6417729892444572182011-02-07T08:00:00.001+01:002011-02-07T09:06:57.682+01:00

If you strongly believe that Oracle XE (10g) was a great piece of software, as I do, and it's time to release an update in line with the current database offering, may be you should sign up for the following feature request:Oracle XE 11G petitionLong live Oracle XE!

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com6tag:blogger.com,1999:blog-18037024.post-51805456709810852972011-01-18T08:00:00.002+01:002011-01-18T08:00:00.870+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.One of my favorite techniques for sending emails from Apex is to put the text of the message in a page region and then retrieve it through the apex dictionary. In most cases this text contains some substitution strings that i need to replace with a dynamic value, pretty much in the same way

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-71316726108080488662011-01-12T11:15:00.001+01:002011-01-12T11:15:00.806+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Imagine that you need to set up Oracle Application Express and Oracle HTTP server on an existing system (Oracle 10R2 SE on Windows 2003 server in my case).The installation requires that you install Oracle HTTP server in a new oracle home.After successfully installing Oracle HTTP Server (

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-36157423844887565202011-01-10T11:45:00.001+01:002011-01-10T11:45:00.425+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.ORA-12162: TNS:net service name is incorrectly specifiedIf you see this message, probably you tried to connect to an oracle instance without providing a service name on a linux/unix box, for instance:sqlplus SYS AS SYSDBAThis command may succeed only if in the client environment exists a

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-89939036953740549042010-12-20T08:00:00.002+01:002010-12-20T08:00:03.844+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Even if I found out later that i am only three years late in discovering the situation I am going to describe, when i saw the results i was really puzzled.I don't know if i was more puzzled by the curious handling of the NO_DATA_FOUND exception in SQL or by the fact that i stumbled on it

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-40735383116702884932010-12-09T13:15:00.004+01:002010-12-09T13:21:16.135+01:00

Don't ask me why, but here is how the official Oracle Apex page looks like today.I definitely need to learn some chinese!PS: i checked if i had selected chinese in my browser's preferred languages, but i didn't...

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com4tag:blogger.com,1999:blog-18037024.post-45352498344342214712010-10-17T23:40:00.001+02:002010-10-17T23:44:00.428+02:00

Benoît Mandelbrot passed away a couple of days ago, but the news wasn't reported until late saturday.I remember spending countless hours drawing the Mandelbrot set on a HP workstation some 24 years ago.Farewell Dr. Mandelbrot!

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-49022245580237970442010-10-14T18:15:00.003+02:002010-10-14T18:26:12.553+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.When working on large Apex projects, it's easy to create components that shortly after must be discarded because the customer changed his mind on a certain feature or we found a better solution for a certain problem.So, it may happen that shared components like list of values, in short LOVs

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-55165455404444621772010-10-13T20:53:00.003+02:002010-10-13T21:01:28.099+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Shortly after the release of SQLDeveloper Data Modeler, the awaited SQLDeveloper 3.0 early adopter version has been released today.I'm very pleased to see that SQLDeveloper now includes a full fledged node for DBMS_SCHEDULER, something I've been longing for ever since and it really looks

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-53186364880659692702010-10-13T10:30:00.002+02:002010-10-13T10:37:47.879+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Ever needed to duplicate a region along with its items within the same page?If you attempt to copy a region and its items to the same page, you will get the following message in Apex 4.0:This restriction can be easily circumvented by first copying the region to a different page and then,

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-49635757151104246172010-10-12T10:05:00.001+02:002010-10-12T10:11:50.401+02:00

Recently i heard that in a few countries of the world, the access to internet has been declared a primary need.I believe Finland and Iceland are among the countries and i have no doubt that they are taking the web very seriously.But as it always happens with us Italians, the so-called primary need could be interpreted in a different way altogether, as we shall see.So, what is a primary need in

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-22968702368631738972010-10-11T14:42:00.003+02:002010-10-11T14:48:29.196+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Breaking news about SQL Developer Data Modeler FREE Early Adopter version.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-85450095595145358982010-10-07T09:50:00.012+02:002010-10-07T11:15:17.112+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.A year and a half ago I published a short article about apex 3.2 dictionary's new entries in comparison with version 3.1.It's now the time to re-run those queries against Apex 4.0.1 and Apex 3.2.1.Given the wealth of changes introduced with Apex 4.0.1, the total list of new columns exceeds

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-60989192977478766712010-10-01T11:59:00.003+02:002010-10-01T12:15:39.630+02:00

As I owe to the prestigious Annals of Improbable Research the inspiration for the title of this blog, i thought that we could end this week with a good laugh by reading the list of this year's winners of the IG-Nobel awards.I am particularly happy for my fellow countryman who won the Management Prize by "demonstrating mathematically that organisations would become more efficient if they promoted

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-75953655197482779392010-09-24T16:00:00.001+02:002010-09-24T16:08:41.653+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Today i learned something new about the mutating trigger error and in particular i learned that under certain conditions, without implementing any workaround, the trigger will work without issuing such exception.I was reviewing some code written by other people and i stumbled upon the

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-44715127446584346212010-09-17T11:30:00.001+02:002010-09-17T11:32:22.750+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.It's amazing how much time one can waste because of certain bugs.Yesterday evening i got the following stack of errors upon importing (IMPDP) a dump made on Oracle 11.1.0.7.0 to 11.1.0.6.0.ORA-39002: invalid operationORA-31694: master table "SYS"."SYS_IMPORT_FULL_01" failed to load/

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-39089794053427433392010-09-10T23:28:00.003+02:002010-09-10T23:37:32.813+02:00

An intriguing SQLException unknown error exposing some code on the Amazon Web Services home page that corresponds to the recent announcement of the new ultra-low-cost micro-instances.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-30547764289239726582010-08-19T09:09:00.003+02:002010-08-19T09:16:50.083+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.In case you went to sleep early yesterday night, Apex 4.0.1 was released in the meanwhile.All details courtesy of Joel Kallman.Enjoy

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-10161674861747778902010-08-06T17:50:00.003+02:002010-08-06T18:02:59.483+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.I just found out that columns ENQUEUE_ENABLED and DEQUEUE_ENABLED in views DBA_QUEUES, ALL_QUEUES and USER_QUEUES, return a couple of (unnecessary?) leading and trailing blank characters.select name, queue_type, translate(dequeue_enabled, ' ', '.') dequeuefrom dba_queues;NAME

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-27311802519092079442010-07-28T17:20:00.001+02:002010-07-28T17:20:00.090+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.A quick posting to report that, for some (good?) reason, Oracle decided to change the values behind the so-called exit codes that SQL*Loader returns upon exit on the Windows platform.Interestingly enough, this change is actually "documented" because comparing the two pages in the "Utilities

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-10194393114400483742010-04-15T15:15:00.001+02:002010-04-15T15:25:49.581+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.While most Apex applications will continue to work normally after upgrading Oracle Application Express to the latest version, there can be some applications that do not work as expected under all circumstances.How do we know which applications are the most likely to fail?This question can

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-30728654495434817482010-04-08T18:30:00.004+02:002010-04-09T17:03:55.358+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Yesterday i needed to find a way to ensure that a list values entered manually by a user were unique.If these values came from a table, it would be fairly easy to build a query returning DISTINCT values, but in this case values are pulled in as comma separated values.This type of problems

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com3tag:blogger.com,1999:blog-18037024.post-76883721568995976632010-03-25T14:00:00.001+01:002010-03-25T14:16:24.997+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you install Oracle 11.1.0.7 on a Windows x64 platform, a prehistoric version of SQL Developer is also installed in ORACLE_HOME\sqldeveloper, but, according to the release notes, it's unsupported or, better said, there are a couple of bugs that prevent you from running it

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-57980627897501159072010-03-22T22:31:00.004+01:002010-03-22T23:06:34.700+01:00

By this time probably everybody in the Apex development community knows that one of the most prominent figures of the Oracle team, Scott Spadafore has passed away.When we met, for some reason, the discussion inevitably slipped off the "Apex" rails to touch on the italian cuisine, that he was very fond of, a tribute to the grandparents, allegedly originating from Genoa and, being one of the few

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-58760482214201539032010-03-04T10:06:00.005+01:002010-03-05T12:05:56.475+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Oracle Open World 2010 Call for papers has started...And the deadline for the submission is March 21.See you in San Francisco then!

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-66191403840697184002010-02-08T16:45:00.006+01:002010-02-08T16:57:31.901+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Today was a good day because i finally managed to allocate some time and get to the bottom of an old standing issue that I've been encountering at intermittent times during the last five or six years spent developing applications with Apex:how come that sometimes page item initialization

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com7tag:blogger.com,1999:blog-18037024.post-46708547233237146702010-01-07T15:15:00.010+01:002011-03-15T16:19:32.736+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you are an enthusiastic user of Apex in combination with Oracle XE as i am, you may have encountered the following issue sometimes: suddenly a process called dispatcher (xe_dnnn) starts consuming 99% of CPU time without any apparent reason.Unfortunately i failed to find a way to

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-63251434861327502812009-12-19T11:43:00.002+01:002009-12-19T11:49:26.863+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.In case you didn't spot the news yet, Apex 4.0 Early Adopter release is finally available for testing at tryapexnow.com.Sign up for a free workspace and experiment with a whole array of new, long awaited, features.Have fun.See more articles about Oracle Application Express or download tools

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-22349060623779815792009-12-10T14:50:00.000+01:002009-12-10T14:52:14.291+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.I had to find out some records whose primary key was not referenced in a secondary table and for some reason i mindlessly executed the following (typical) query:select *from qq_messageswhere messageid not in(select messageidfrom qq_message_recipients);Unfortunately each table contained

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-20621568190330845252009-11-03T13:00:00.002+01:002010-01-27T15:58:42.618+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. A couple of weeks ago i finally managed to complete a quick demo page showing a technique for displaying label tooltips without using Ajax or Javascript. In practice, this means displaying the help text associated with the page item inside a sort of balloon that pops up whenever the mouse

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com3tag:blogger.com,1999:blog-18037024.post-28579358823120014012009-09-28T09:20:00.002+02:002009-09-28T09:53:06.924+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.I'm not going to make this longer than necessary, for the simple reason that i could not find a way to scientifically re-create the conditions that led to this error, although i managed to see it twice.This happened on Oracle XE running on Xubuntu linux.select * from USER_QUEUE_SUBSCRIBERS;

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-37453420597610529612009-09-23T09:10:00.001+02:002009-09-23T12:05:59.821+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.After a fortnight spent working with DBMS_AQ and DBMS_AQADM packages, i'd be ready to feed oraclequirks with interesting situations for days, if not weeks if only i had enough time to do so.Unfortunately i am rather busy sorting out some important stuff before leaving or OOW 2009, so i

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-54240318056010510292009-09-10T16:50:00.005+02:002009-09-10T17:00:10.765+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This is one of those funny messages where the lucky user is invited to contact Oracle support.I don't know exactly how many calls Oracle is receiving reporting this, but in most cases it doesn't really make sense.Anyway, here is an example, run on Oracle XE (10.2):SELECT to_timestamp_tz('

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-35159971128379193092009-08-26T08:45:00.001+02:002009-09-04T15:38:15.291+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Apex 3.2.1 is now available for download from OTN.The full package is meant for upgrading versions 3.1.2 and earlier, whereas Apex 3.2 installations can be upgraded by downloading and installing patch 8548651 from metalink, as per accompanying Release Notes.See more articles about Oracle

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com2tag:blogger.com,1999:blog-18037024.post-17822761862470119692009-08-20T12:20:00.001+02:002009-08-20T12:38:21.182+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Sometimes i wish certain things were a little bit easier.I was attempting to import a datapump export obtained with the DBMS_METADATA "demo" export program i mentioned a while ago, but unfortunately it blows up while processing trigger information.After investigating the problem, it seemed

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-25803273648166943212009-08-14T09:35:00.000+02:002009-08-14T09:37:45.028+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.You may incur in this exception when attempting to refresh a materialized view using procedure DBMS_VIEW.REFRESH, but i guess that also autorefreshing snapshots may suffer the same problem, although i could not verify this. ORA-12008 is a catch-all exception that is followed in the error

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-91159291831561709522009-08-07T17:30:00.002+02:002009-08-07T17:34:50.901+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.After discovering two undocumented procedures in package DBMS_XDB in Oracle XE (10gR2), i was eager to try out a configuration of a secondary listening endpoint.These two undocumented procedures, called DBMS_XDB.SetListenerEndpoint and DBMS_XDB.GetListenerEndpoint, are actually documented

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-18787815386364346562009-08-06T19:25:00.000+02:002009-08-06T19:28:44.899+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.A quick note in case one is getting the following exception while using APEX_MAIL.SEND procedure.ORA-29279: SMTP permanent error: 554 5.7.1 : Relay access deniedORA-29279 is a sort of catch-all exception for a whole class of SMTP errors, so the SMTP error code (in this case 554) followed by

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-41159825309201447712009-08-05T09:00:00.000+02:002009-08-05T09:14:45.059+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This exception occurs when you specify a custom function (or packaged function as shown below) as default value for a table column.create table test4044 (code varchar2(10) default dbms_random.string('x',10));Error at Command Line:2 Column:26Error report:SQL Error: ORA-04044: procedure,

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-81779181158369050642009-08-03T15:30:00.004+02:002009-08-03T15:34:23.495+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Recently i had to find out a way of overriding an Apex validation rule on user request.Imagine the following scenario:if item longer than 10 bytes then raise errorelse if item longer than 5 bytes then ask the user and continue if confirmedIn other words, the concept here is to discourage

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com6tag:blogger.com,1999:blog-18037024.post-10538270695612280072009-07-31T16:25:00.001+02:002009-07-31T16:32:20.442+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This morning i was trying out a demo of DBMS_DATAPUMP found at psoug.org and initially i wasn't getting the expected file dump, so i slightly modified the procedure in order to understand where it was stopping. The problem with this nice demo is in that it must have been written for Oracle

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-34611511505068193342009-07-23T08:00:00.002+02:002009-07-23T08:00:01.196+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.I was working with one of my Vmware Fusion VMs, when the VM autoprotect backup started.I don't like particularly the way this feature has been implemented in VMWare Fusion as it doesn't offer any scheduling option, it just based on some funny "elapsed time since last backup" setting that

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-88385788012804077592009-07-22T09:30:00.001+02:002009-07-22T09:30:00.486+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you could not make it to ODTUG Kaleidoscope 2009, held in Monterey last June, you can still watch a lot of cool Oracle Application Express presentations covering many different facets of this framework, by downloading the powerpoint slides or the PDF equivalent, as reported by David

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-27121241830490827502009-07-21T08:00:00.004+02:002009-07-21T08:00:00.183+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Every day is a good day for learning something new.For instance yesterday i learned that there are two distinct ways of enabling partial page refresh for reports in Oracle Application Express. The second thing i learned is that one method excludes the other one...Just to clarify the matter,

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-21502825909283949212009-07-20T11:00:00.002+02:002009-07-20T12:13:39.522+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.As good last, in case for some reason you didn't spot this news in other apex related blogs, i recommend watching Mike Hichwa's presentation (also starring David Peake and Jason Straub from the apex team) about the upcoming version 4.0 of Oracle Application Express recorded at ODTUG

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-34622695032088396242009-07-16T12:00:00.001+02:002009-07-16T12:02:31.496+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This exception is raised when an attempt of updating the rows of an atomically null nested table column is made.For instance:create type complex_number as (real_part number, imaginary_part number);create or replace type complex_tab as table of complex_number;create table complex_sets (

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-84669925925162094072009-07-15T17:30:00.001+02:002009-07-15T17:30:34.880+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Just a quick note to let you know that SQL Developer 1.5.5 is available for download.You can read some details about this in Sue's latest blog posting.The first thing i notice after installing it on one of my Macs is that now table icons are no longer differentiated between normal (heap)

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-19682764991660893302009-07-03T07:45:00.000+02:002009-07-08T12:21:26.578+02:00

Another great conference has just been archived and i must say i really had a good time at ODTUG Kaleidoscope 2009.Can you believe it?I even swam with Tom Kyte, but he didn't know i was a fan of his, so i preferred to not bother him with my silly questions about the optimizer while he was peacefully floating in the pool at the hotel.This bizarre coincidence was caused by the fact that most people

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-47503903278601045932009-07-02T10:15:00.000+02:002009-07-02T10:19:12.989+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This morning i realized that Firefox 3.5 had been released.Soon after installing the new version, i had a feeling that something went wrong with my current bookmarks library because many recent entries were gone.Actually i think that firefox restored (for some unknown reason) an old version

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-46341301723367159442009-07-01T17:55:00.010+02:002009-07-02T15:18:44.501+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Just a "quickie" to let you know that as of today you can download SQLDeveloper Data Modeler tool release 2.0.0.57.0.After installing as suggested on the official page, in case you are running the tool on Mac OS X, you might get the following java exceptions:Exception in thread "main"

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com3tag:blogger.com,1999:blog-18037024.post-19545198834768826322009-06-03T12:20:00.003+02:002009-06-03T12:53:59.193+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This is another curious error message that i presume is rare to be seen twice in your life.alter session set tracefile_identifier="";ORA-01741: illegal zero-length identifierOracle accepts the double quotes as string delimiter, but not when there is nothing in between.In fact it is

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-47438292545879664312009-05-19T11:50:00.002+02:002009-05-22T11:24:24.055+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This type of parsing error is quickly explained:select dbms_db_version.version from dual;SQL Error: ORA-06553: PLS-221: 'VERSION' is not a procedure or is undefinedIn the example above dbms_db_version.version is not a packaged function, but a packaged constant.Packaged constants can be used

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-78479779827797857532009-05-15T15:45:00.003+02:002009-05-15T15:57:49.420+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Little problem of the day:how to check for the oracle database version currently running from inside a PL/SQL program or query?I knew there were various built-in dictionary views for checking the version of installed components, but i had another requirement, i wanted to run this query

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com5tag:blogger.com,1999:blog-18037024.post-50807373398352366892009-05-12T14:40:00.000+02:002009-05-12T14:46:48.858+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Did you ever need to find out where a certain build option was specified inside an apex application?Build options are a useful feature of Oracle Application Express that allows a developer to enable or disable certain functions or components by simply changing the value of the associated

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-53292657460142005782009-04-30T13:00:00.002+02:002009-04-30T16:21:37.891+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.I was testing a recently created tree region in an Oracle Application Express application when upon displaying the page, instead of nice tree diagram, i got the following message:Warning: Tree root ID "0" not found.The first thing that came to my mind was to check if the underlying

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-76691951689830411472009-04-29T10:00:00.000+02:002009-04-29T10:06:52.102+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This morning I'm going for an easy one.... l_doc := DBMS_XMLDOM.newDomDocument(cl => l_clob); l_rootElem := DBMS_XMLDOM.getDocumentElement(doc => l_doc); DBMS_XMLDOM.freeDocument(l_doc); l_rootNode := DBMS_XMLDOM.makeNode(elem => l_rootElem); -- this is line 436 DBMS_XMLDOM.freeNode(

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-73829178576972529282009-04-27T10:20:00.001+02:002009-04-27T10:24:59.330+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Lately I'm working a lot with XDB.At the same time, having some spare time to investigate a few outstanding "issues", i decided to search the web for information about alert log messages like the following:Memory Notification: Library Cache Object loaded into SGAHeap size 2208K exceeds

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-835070379080195662009-04-21T16:15:00.002+02:002009-04-21T16:27:04.304+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.It's not the first time i write about the stack of errors returned by data pump operations and ORA-31641 in particular, however the error messages may vary slightly with the operating system. For instance the following error stack is returned on XE running on top of Ubuntu, whereas the

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-76747162854767895182009-04-20T14:56:00.003+02:002009-04-20T15:01:43.555+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.It looks like Larry Ellison had some leftover in his pocket this morning...

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-3948220704683378822009-04-15T18:00:00.000+02:002009-04-15T18:02:27.297+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.You may get the following error when you combine DISTINCT and ORDER BY clauses in a query as follows:select distinctagent,application_idfrom apex_workspace_activity_logorder by view_date;ORA-01791: not a SELECTed expressionThe problem is caused by the presence of column view_date in the

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-80391646464245901082009-04-10T23:15:00.001+02:002009-04-14T11:35:25.643+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you didn't hear the latest news, Oracle 10gR2 for Mac OS X is officially available for download.Thanks to Scott Spendolini for reporting this exciting news.Awaiting to finish the download and to begin the installation on Mac OS X 10.5.6.Updated April 14. If you are primarily interested

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com4tag:blogger.com,1999:blog-18037024.post-42971888361549410492009-04-10T17:45:00.001+02:002009-04-10T17:48:15.318+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.This morning i discovered the following messages in the alertXE.log, located in the bdump folder of a xubuntu virtual machine:Fri Apr 10 15:01:15 2009Starting ORACLE instance (normal)Cannot determine all dependent dynamic libraries for /proc/self/exeUnable to find dynamic library libocr10.

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-68643333801933655492009-03-30T11:10:00.001+02:002009-03-30T11:19:17.191+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Lately I'm working a lot with UTF-8 files and while doing some test i came across the following situation, which sounds rather odd at a first sight but it's perfectly legitimate in the way Oracle treats multi-byte strings, so i thought it could be an interesting story for those who rarely

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-28359074120672412022009-03-26T08:30:00.001+01:002009-03-26T08:30:18.126+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.As mentioned in a previous posting about ORA-22275, a temporary LOB can be turned into a persistent LOB by moving it into a table, however one thing is persistence and a different thing is LOB consistency.Funny things happen when one gets fancy in the use of SAVEPOINT/ROLLBACK in

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-7861181848607845412009-03-25T10:15:00.004+01:002009-03-25T12:03:53.313+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.You may get ORA-22275 in the following situation:declarel_clob clob;beginl_clob := dbms_xmlgen.getxml('select * from user_tables'); dbms_lob.freetemporary(l_clob);insert into files(document) values(l_clob);end;/ORA-22275: invalid LOB locator specifiedORA-06512: at line 6The problem here is

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-78319421622833124222009-03-19T15:00:00.004+01:002009-03-19T21:54:00.450+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you are wondering why you are getting the following pop-up screen when attempting to edit a procedure (or a trigger, a type or anything else that can be edited in the editor panel, but not views for instance) after upgrading to the latest version of SQL Developer (1.5.4)...ORA-00904: "

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com6tag:blogger.com,1999:blog-18037024.post-6928342529789476662009-03-17T15:50:00.000+01:002009-03-17T15:56:29.953+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.In case you are wondering what's new inside the apex 3.2 data dictionary, the following query run from SQL Workshop will quickly return the desired answer.select table_name, column_name from all_tab_columnswhere owner = 'APEX_030200'and table_name like 'APEX%'minusselect table_name,

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-4394753508991100282009-03-13T11:53:00.009+01:002009-03-13T12:21:13.724+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Yesterday i upgraded SQL Developer from version 1.5.1 to 1.5.4 and when i opened it, i noticed that the user interface was automagically showing up in Italian.I say automagically because i am italian indeed, but the operating system on this particular machine is localized in mexican-spanish

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com25tag:blogger.com,1999:blog-18037024.post-84676850534405442332009-03-11T12:30:00.001+01:002009-03-11T12:37:24.021+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.There are oracle errors that can be easily explained.Sometimes one of these trivial error messages pops up in an unexpected situation and it's really tough to get to the bottom of it.And that is exactly what happened yesterday, but i am still doing some tests today.Let's see first the

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-3642441386356169012009-03-06T19:00:00.004+01:002010-05-13T16:40:24.047+02:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.I like jokes as you can understand from the title of this posting, however i was in the mood for it because sometimes i happen to read FAQ lists where there are questions that i'd never ask in centuries, hence the idea of a SAQ list.Apex globalization mechanism is extremely powerful and

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com9tag:blogger.com,1999:blog-18037024.post-28706125684921083542009-02-25T15:30:00.001+01:002009-02-25T15:30:23.870+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.A quick tip for the lazy apex developers like me.If you manage many workspaces on different machines and servers, you may want to create several bookmarks to quickly preset the workspace name and the workspace administrator name or an application developer name if you prefer.Being Apex a

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-84692380222339168892009-02-18T15:20:00.000+01:002009-02-18T15:22:00.369+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you are a skilled developer, feel free to skip reading this entry aimed to Oracle newbies ;-)SELECT apex_util.is_username_unique('BOB')FROM dual;SQL Error: ORA-06552: PL/SQL: Statement ignoredORA-06553: PLS-382: expression is of wrong typePackaged function APEX_UTIL.IS_USERNAME_UNIQUE

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com1tag:blogger.com,1999:blog-18037024.post-17995324747424881202009-02-13T16:25:00.001+01:002009-02-13T16:28:50.613+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.You may get the following bizarre error message when invoking the Oracle Application Express API procedure: APEX_UTIL.CREATE_USERORA-02291: integrity constraint (FLOWS_030100.WWV_FLOW_FND_GU_INT_U_FK) violated- parent key not foundFor instance, suppose you have a registration page where

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-51785133111457036732009-01-29T11:45:00.002+01:002009-01-29T11:50:06.482+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Further to my last posting about DBMS_METADATA related ORA-31607, here is a slightly modified version of an Oracle supplied sample of procedure performing the "dump" of all the objects belonging to the current user. In red color, i highlighted the cause of ORA-31600.The original program

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-53196986271936659442009-01-28T17:40:00.001+01:002009-01-28T17:41:55.156+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.If you wonder why you are getting the following error message attempting to use DBMS_METADATA.FETCH_DDL:ORA-31607: function FETCH_DDL is inconsistent with transform.then you might want to ensure that your program contains the line in green color call prior to calling FETCH_DDL.declare...

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com0tag:blogger.com,1999:blog-18037024.post-47075984665367494792009-01-16T23:45:00.005+01:002009-03-13T12:08:05.269+01:00

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.A quick note for those who came across a weird bug in Oracle SQL Developer that makes its editor virtually useless under Mac OS X.If you are wondering why suddenly the backspace key doesn't work or the arrow keys simply do nothing, it seems that, for some reason currently being investigated

Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.com12