OraNA :: Oracle News Aggregator

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Just a simple reminder (I tend to forget things over the centuries) when using procedure DBMS_LOB.CONVERTTOCLOB with persistent lob locators: don't forget to include the FOR UPDATE clause in the SELECT statement fetching (more...)

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. I don't know why it took me more than the necessary to understand where was the problem when I hit the following error. ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00209: PI names starting with XML are reserved At any rate, in my case the reason was

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. If you, like me, think that it could be useful having text messages available as substitution strings (ideally using the #syntax#) inside certain Apex's element attributes like button attributes, report links, form attributes and so on, then you might want to vote for this feature request

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Even if the topic is no breaking news, there are some references about it in the Apex OTN forum, it may be still worth spending a few words, especially because, up to date (Apex 4.2.1), there is no trace of it in the official Oracle Application Express documentation. I am talking of the

Apex 4.2.1 has been made available for download today. I recommend checking out Joel Kallman's blog posting for the details (bug fixes, patch notes and release notes). Enjoy

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. The story goes that at a certain point I began seeing ORA-12952 in my logs when Oracle was trying to refresh  schema statistics, then, progressively, I started receiving this error message while attempting to perform certain operations involving lots of data, until the other day, when

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. I love when a perfectly working application suddenly begins complaining about: ORA-29024: Certificate validation failure Last year it took me a while to fix it as I had to figure out how to cope with the absence of a wallet manager on Oracle XE. Now things were different. I began

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. First of all many thanks to Patrick Wolf for explaining me the reason of this bug and contributing a quick workaround. The story goes as follows: if you install Apex 4.2 on a fresh database or upgrade an installation of Apex 4.1 where there are no existing workspaces and you plan to

Apex 4.2 has been finally made available for download on saturday night. Joel Kallman and David Peake announced the release giving some preliminary details. According to the newly restyled official Oracle Application Express page, Apex 4.2 sports jQuery Mobile support,  responsive web design on theme 25, HTML5 support for charts and more. A few days ago Oracle made available also some videos

Breaking news: SQL Developer 3.2 is available for download. Follow the link to get a grasp on the new features.

Freshly backed news from Amazon... Apex 4.1 now available on Amazon RDS for Oracle

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. A short account of a couple of occurrences of ORA-27486. exec dbms_scheduler.create_job_class('TEST_CLASS'); Error starting at line 1 in command: exec dbms_scheduler.create_job_class('TEST_CLASS') Error report: ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Did you get ORA-12899 and its associated IMP-00019 while attempting to import an old-style EXP dump?  IMP-00019: row rejected due to ORACLE error 12899 IMP-00003: ORACLE error 12899 encountered ORA-12899: value too large for column "TEST"."TMAGANFS"."DESCR" (actual: 51, maximum: 50)

Oracle Application Express 4.2 Early Adopter release is now ready and can be tested online at the following address: https://apexea.oracle.com You can check out in advance what's new in this release at the following address: http://apex.oracle.com/pls/apex/f?p=38997:1:0 More information available in Joel Kallman's blog. Enjoy

This articles discusses a workaround that might hamper the throughput of your production web site, it might be wise to implement this technique only for the time strictly needed to carry out the required investigation. It's amazing how you end up spending hours on a secondary problem when you start investigating a completely different one. I set out in pursue of an allegedly trivial problem with

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Yet another web article about ORA-02080? Hopefully not. ORA-02080: database link is in use After reading several entries on this error and its remedies, including Tom Kyte's entry, I realized that the suggested cure is not always working, at least not on Oracle XE 10gR2 (at the moment I

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Look at this (my session date format is DD/MM/YYYY): select to_date('2011','YYYY') d from dual; D --------------------- 01-02-2011 00:00:00  select trunc(to_date('2011','YYYY'),'Y') d from dual;D --------------------- 01-01-2011 00:00:00 I didn't

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Can't find why Apex 4.0 is returning the following error? If you copy and paste the error message into a fixed-width text editor, you'll will hardly notice that there is an extra space between the first double quotes and the name of the item, that I highlighted in red color.

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

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"