At some point during APEX development you may find yourself putting an Oracle APEX page within an iFrame.
Just recently I did just that and came across an error I expected to see, but a little curious as to how it presented itself.
Refused to display '//myserver.com.au/ords/f?p=SAGE:1023:30559832045078' in a frame because it set 'X-Frame-Options' to 'DENY'.
Googling the last half of the message returns some interesting (more...)
Kscope15 is insanely close and I'm very excited to be making the journey this year.
A few months ago I made a list of presentations that piqued my interest to try encourage a business colleague to come along. Maybe this list will encourage someone to join what I understand to be the world's best conference for APEX developers.
The APEX topics listed in full herehttp://kscope15.com/component/seminar/seminarslist?Itemid=57&topicsid=2
The links below go directly to the (more...)
I'm sure we've all done it at some point or another, used some "feature" in the database you're probably not meant to.
Interactive reports still have a few misgivings prior to APEX 5 so some tried to utilise gReport object, since it was available in the generated page but undocumented - which in Oracle speak means that they're more than entitled to change behaviour in future without telling or supporting you.
I understand htmldb_Get put (more...)
Attention Perth Oracle technologists.
I'll be giving a dry run of my Kscope talk
to the user group in Perth on May 28th, which happens to be the deadline for us to submit copies of our sessions to ODTUG.
So if you're in Perth, have any form of interest in APEX - come by the Oracle offices in near Kings Park by 8am, or come a bit earlier for a feed.Evidence-Based APEX: Building Better Practices
The polish that comes with APEX 5 also extends to the generic login screen used for the Open Door Credentials
This scheme is great for testing. It allows you to log into the application by supplying just a username, as if you logged in normally - saving on user management in test servers.
The login screen used isn't page 101, but a generic page generated via wwv_flow_custom_auth_std.login_page. Prior to APEX 5 the page (more...)
I love podcasts. I listen to a few good science shows every week and I've been looking for some decent software related shows, and this one hits the subject matter right on the head.
Juergen states he hopes to interview many developers from the APEX team, offering perhaps a recording per month. Not limiting (more...)
There are some stickers are out there causing quite the sensation
in the Oracle APEX Twitter community. Check it out and join the conversation.
A couple of weeks ago I received my sticker from the master dealer, Juergen
, so I thought I'd share my pimped up laptop, complete with sticker friend.
|Pimp my laptop|
Fun fact: the photo was taken on the same grass that formed my blog's title image.
And now I also learn (more...)
Tonight I stayed up way past my bedtime (well, in the days of writing a book and Kscope presentations, midnight isn't that
I watched and listened to Shakeeb Rahman from the APEX team on an ODTUG webinar
, which was recorded and available for ODTUG members.
I did, however, take some notes. I thought I'd share:
Not shy about reference to Douglas Adams.
Theme can be (more...)
This is why I can't do webinars
from my current home.
The upload speed is no doubt way too slow to cater for voice and screencast. Unfortunately I also seem to be in quite the dead spot for 4G wireless connection.
Download speed might
be enough to support the streaming services recently launched in Australia, but I know ABC's iView
does stutter occasionally so I think I'll still have to wait (more...)
Have you discovered the OTech Magazine
This magazine is a brainchild of Douwe Pieter van den Bos
and is now five quarterly issues young. The "Winter 2014" is a bumper issue this time, plenty of reading during various downtime that's typically afoot. The season in particular deserves quotes, since outside my home it's currently 39C.
I hope to publish something again next issue, should I find the time between a couple of other projects. (more...)
There was movement at the station, for the word had passed aroundThat the APEX version 5 will become available.
I've jumped the gun
before, but this message is taken direct from the apex.oracle.com site:
No doubt you've heard the news already, but I had to chuckle a little today as I did about an hour's work on a 3.2 environment. After playing with APEX 5 EA3, it was like jumping (more...)
I've finally bitten the bullet and disabled the Google+ commenting mechanism from this blog. I promised this in my 2014 annual review
, and I figure I might as well not wait.
When Google announced they would integrate Google+ with blogger, it sounded like a good idea at the time. However it required that commenters needed a Google+ account as opposed to having a number of authentication options.
Unfortunately this means the many comments made (more...)
Do you live in Perth, Western Australia?
Do you use Oracle Application Express?
Are you interested in seeing how easy it is to extend the product?
Keen to see APEX 5 in action?
Please tell me you're free for breakfast on Tuesday March 24. You'll be out by 9am feeling glad you came. Visit the event details page
for the abstract, it's inspired by a book I'm currently writing ;p
Sometimes I come across code where it's obvious someone has taught themselves APEX, then worked through a problem to come up with a solution - but they went a long
Today's situation required data in an interactive report to not wrap the output. I thought it'd be worth sharing because a few lessons might be demonstrated along the way for newer developers.
Here is the long way:
1) Add this to the Page Load (more...)
Thanks to twitter I found this post
by Carsten Czarski on LISTAGG and CLOBS that helped my with the 4000 character limit with LISTAGG(), found when building JSON strings.ORA-01489: result of string concatenation is too long
I follow a few bi-language blogs but I do wonder if English speakers may find this post when googling the issue. For me it's on page 1 when googling "listagg clob", but I knew what keyword to search (more...)
Once upon a time I had a laugh on facebook when someone posted an image
showing multiple groups dedicated to stopping duplicate groups, oh the irony.
Recently I've been trying to share my blog posts via LinkedIn but I'm always unsure which of the seven APEX groups I'm a member of I should post to.
It turns out only the SIG groups are owned by those involved with the APEX development team, namely David Peake (more...)
There are a bunch of sample APEX applications out there built by developers (typically with blogs) that are darn useful, but so far I haven't seen a useful central repository.
So I've started one here with a very basic form/report:https://apex.oracle.com/pls/apex/f?p=73000:APEX_SAMPLES
At the moment it's just a list of those I happened to have bookmarked over time, in one place that others could use and perhaps contribute to.
Depending on feedback I (more...)
Steven Feuerstein runs a great site at PL/SQL Challenge
that is just another way for developers to stay up to date with their knowledge of PL/SQL, SQL and database design with a bit of fun.
PL/SQL championships are held quarterly, but the less frequent SQL and Database Design quizzes are currently held annually. Thanks to persistence and maybe a bit of experience, I was eligible to compete in both.
Unfortunately do to a timing
Scott Spendolini conducted a little experiment
last week, then Jeff Smith & Kellyn Pot'Vin whipped up a little slideshow
on the topic.
I thought I'd chime in after some recent experiences were helped along by the use of Twitter, a tool it seems many are underutilising.
I had an afternoon of generating JSON with SQL using LISTAGG and I kept facing this issue of being limited by 4000 characters. Knowing I occasionally (more...)
I was inspired by Peter Raganitsch
to use the Survey Builder packaged application to create a survey that will help with my "Evidence Based APEX
I would appreciate 5-10 minutes of your time if you could fill out my survey:https://apex.oracle.com/pls/apex/f?p=70347:Q::AAC3
You'll find a small set of questions over five major topics.
- Instrumentation (debugging)
In time I'll discuss the results, I look forward to reading your responses.