Bug of the week: REP-52262 Diagnostic output is disabled when using reports server 11g on new installation
You may have noticed that when you have a new installation of reports 220.127.116.11 when you try to run a PDF report or even if you simply try to do a showjobs request you get the error REP-52262 Diagnostic output is disabled. It seems that in a (more...)
Here is a short story about a little problem that caused me a bit of grief; but in the end had a simple cause and a simple fix.
I had a dynamic action in my Apex 4.1 app that had to run some PL/SQL – which was working fine, (more...)
Here is a new Forms Java Bean that allows to handle a typical "Breadcrumb" HTML menu type.
Logger is a PL/SQL logging and debugging framework. It’s used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0. After some great feedback, I’m pleased to announce (more...)
drop procedure is_not_really_gone_but; select object_name || ' ' || object_type as "Continues on" from user_objects_ae where object_name = 'IS_NOT_REALLY_GONE_BUT'; Continues on ----------------------------------- IS_NOT_REALLY_GONE_BUT NON-EXISTENT create table is_not_really_gone_but ( until_replaced number, by_a_non_editioned_object varchar2(1) default 'Y', which_we_then_drop varchar2(1) ); drop table is_not_really_gone_but; select (more...)
Warning: While this appears to work, I do not know if the behavior is defined.
It seems that using a scalar subquery in the select list of an updatable view allows us to return the old value of a column. I’ll update this post with more details when I (more...)
Tom is not not a fan of public synonyms, here is why:
- public synonyms pollute the namespace.
- public synonyms can lead to security issues.
- public synonyms can lead to a maintenance headache.
- public synonyms are public – no one owns them.
So, instead of public synonyms…
create PRIVATE synonyms or (more...)
For my newest ipython-sql trick, I needed to compare some queries run across different databases. How hard would it be to get side-by-side results into tidy IPython Notebook output?
Not hard at all, it turns out, if you're willing to violate basic principles of human decency.
That's an itty-bitty image, (more...)
Well, I've had enough of that. (more...)
In the next version of SQL Developer, you'll be able to hold the ctrl key down and click on the file name and have it open up. This also works (more...)
- 4½ days of great technical content for Oracle developers. Plenty of presentations and hands-on training on several areas such as APEX, BI, development tools, SQL, PL/SQL, (more...)
If any of this is ticking boxes for you, it’s time to consider what flash could do for the performance of your database:
- I/O wait times are high. Essentially we are looking for high latency from the existing storage system. Flash memory systems should deliver I/O with sub-millisecond (more...)
There are plenty of options for this, including a number of jQuery plugins, but here is an example that uses only (more...)