Skip to main content

Oracle APEX 3.1 Press Release

Looks like the press release for APEX 3.1 has hit the wire.

Comments

Anonymous said…
Hi Scott,

How about enabling an e-mail subscription to your blog. That would be much more convenient and it doesn't take more than 15-30 mts to set it up.
Raymond said…
Hey Scott,
Is that book of yours ever going to be actually published on paper or will it remain a pie in the sky. Amazon just cancelled my pre-order, because I forgot to reply that I wanted it to remain in pre-order state. Oh well... back to Amazon then.
Stew said…
Scott,

I've had my pre-order with Amazon since January and was very disappointed that they're now saying it won't be til the end of June. Not that it ultimately matters, but I wish I knew if the hold-up was in the writing or the publishing end of things. At this point it's going to be out of date by the time it's delivered. :-(

Sorry to whine, but I've been looking forward to this for a while and really need the help (as you'd see if you saw my questions in the Apex forum).

Best of luck!
Scott said…
Not that it makes it any better, but all of that is out of our hands now. I'm also not blaming the publisher, either - just saying that it takes time to finalize things, especially when this was a side project for both of us.

No one wants it released more than John & I do!

- Scott -
Stew said…
> No one wants it released more than John & I do!

I think we could debate that! You and John already know all these great tips for using Apex, but the rest of us are more in the dark, hunting for tips, AJAX and Javascript snippets and understanding. So we have this burning need for knowledge (and productivity) that you and John have already achieved! :-)

Thanks very much for the reply. It's still hard to believe it take 3 months for a book that's written to get in print and delivered to book stores.

I hope you make lots of money from it, as well as getting lots of personal satisfaction for helping us fledgling Apex developers.
Scott said…
I think we could debate that! You and John already know all these great tips for using Apex, but the rest of us are more in the dark, hunting for tips, AJAX and Javascript snippets and understanding. So we have this burning need for knowledge (and productivity) that you and John have already achieved! :-)

Fair enough. I stand corrected. :)

Thanks very much for the reply. It's still hard to believe it take 3 months for a book that's written to get in print and delivered to book stores.

Yes, I agree, but having never printed one myself, I can only assume that there's more to it than you would think.

I hope you make lots of money from it, as well as getting lots of personal satisfaction for helping us fledgling Apex developers.

If you "lots" you mean enough for a nice meal at the chain restaurant of my choice (sans alcohol), then yes, I will make "lots". :)

- Scott -
Stew said…
Oh wow! If all you wanted was a nice dinner out, I'm sure a few of us would have been able to up that ante for an electronic version and eliminated the long publishing delay.

Heck, send me your PayPal account and an electronic copy and I'll send you enough for a few drinks to go with that chicken-in-a-basket! Seriously!
Scott said…
I'd rather you watch my 2 kids while my wife & I go out for a meal that doesn't involve high chairs or bottles. I'd gladly foot that bill!

- Scott -
Stew said…
I think if 2 of us ponied up for an electronic version, it'd pay for a babysitter (though I've never had to pay one, I can put my little ones in a crate w/o Family Services showing up at my door, they're goldens).

If not, where do you live and what time do you want me there? Weeknights are best. :-)
Scott said…
Do you at least poke air holes in the crate? That would seem like the right thing to do... :)

- Scott -
Stew said…
LOL! Yeah, actually they're well-behaved and have the run of the house. But I do hide the remote control so they don't watch "mature" shows on TV! Thankfully their paws can't type my Windows password.

:-)

Popular posts from this blog

Custom Export to CSV

It's been a while since I've updated my blog. I've been quite busy lately, and just have not had the time that I used to. We're expecting our 1st child in just a few short weeks now, so most of my free time has been spent learning Lamaze breathing, making the weekly run to Babies R Us, and relocating my office from the larger room upstairs to the smaller one downstairs - which I do happen to like MUCH more than I had anticipated. I have everything I need within a short walk - a bathroom, beer fridge, and 52" HD TV. I only need to go upstairs to eat and sleep now, but alas, this will all change soon... Recently, I was asked if you could change the way Export to CSV in ApEx works. The short answer is, of course, no. But it's not too difficult to "roll your own" CSV export procedure. Why would you want to do this? Well, the customer's requirement was to manipulate some data when the Export link was clicked, and then export it to CSV in a forma

Refreshing PL/SQL Regions in APEX

If you've been using APEX long enough, you've probably used a PL/SQL Region to render some sort of HTML that the APEX built-in components simply can't handle. Perhaps a complex chart or region that has a lot of custom content and/or layout. While best practices may be to use an APEX component, or if not, build a plugin, we all know that sometimes reality doesn't give us that kind of time or flexibility. While the PL/SQL Region is quite powerful, it still lacks a key feature: the ability to be refreshed by a Dynamic Action. This is true even in APEX 5. Fortunately, there's a simple workaround that only requires a small change to your code: change your procedure to a function and call it from a Classic Report region. In changing your procedure to a function, you'll likely only need to make one type of change: converting and htp.prn calls to instead populate and return a variable at the end of the function. Most, if not all of the rest of the code can rem

Logging APEX Report Downloads

A customer recently asked how APEX could track who clicked “download” from an Interactive Grid.  After some quick searching of the logs, I realized that APEX simply does not record this type of activity, aside from a simple page view type of “AJAX” entry.  This was not specific enough, and of course, led to the next question - can we prevent users from downloading data from a grid entirely? I knew that any Javascript-based solution would fall short of their security requirements, since it is trivial to reconstruct the URL pattern required to initiate a download, even if the Javascript had removed the option from the menu.  Thus, I had to consider a PL/SQL-based approach - one that could not be bypassed by a malicious end user. To solve this problem, I turned to APEX’s Initialization PL/SQL Code parameter.  Any PL/SQL code entered in this region will be executed before any other APEX-related process.  Thus, it is literally the first place that a developer can interact with an APEX p