Tuesday, August 4, 2009

Apex: /apex/wwv_flow_utilities.show_as_popup_calendar was not found

Since I hate Blogger's reports, ahem, lack of reports, I decided to try out the Google Bogger API to get what I wanted. Specifically, I want a report of posts by month.

I know this is possible as I've seen this on multiple blogs in the Archive or Categories section:

So instead of manually running an anonymous block to populate a table which I will then query, I decided to throw into Apex to make my life a little bit easier.

I create an application with a blank page and create my first item, P1_FROM_DATE. I decided to use a Date Picker (use item format mask):

I then created an item, P1_DATE_FORMAT, with the YYYY-MM-DDTHH24:MI:SS set as the source. When I created the Data Picker, I was thinking there would be some place to select the item, but there wasn't. So I opted to enter the format in the Source section:

Then I ran the page and clicked on the little calendar icon, only to see this:

Off to the Application Express forum and I read a few posts mentioning bad formats.

So I removed the "weird" YYYY-MM-DDTHH24:MI:SS format and voila!

That'll teach me to try something new when I'm rusty.

As a small aside, the date format, is the RFC 3339 format, according to the Google documentation.


Patrick Wolf said...

Hi Chet,

when you get a 404 error it can help when you set the PlsqlErrorStyle mod_plsql parameter to get additional debugging information. In your case it would have shown you the actual error

ORA-01821: date format not recognized

http://www.inside-oracle-apex.com/oracle-apex-got-404-not-found-2/ for details.


Boneist said...

I'm not sure if it's possible or not (never having used APEX) but I think the format you're after is really: YYYY-MM-DD"T"HH24:MI:SS

select to_date('2009-08-05T10:21:00', 'YYYY-MM-DD"T"HH24:MI:SS') dt
from dual;


oraclenerd said...


Thanks for that tip. Since I only have admin privileges at home (11g) I don't have the (daily) opportunity to get in and check this stuff out. Plus, I am still trying to get a grasp on the PL/SQL gateway (EPG).

I'm hoping now that I'm using it more and more I'll be able to debug these things quicker, especially if I have you to help. :)


oraclenerd said...

@boneist (giggle),

I hadn't thought about that. Muchas Gracias. I'll give it a shot tonight.