Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INTERVAL DAY TO SECOND

TimMcMay 27 2013 — edited May 28 2013
I have one page with an interactive report (Page 10) and another with a form to update each entry (Page 20).

The table that these pages refer to have a column called MY_INTERVAL_COL of type INTERVAL DAYS TO SECONDS.

I can successfully display the contents of MY_INTERVAL_COL by extracting DAYS, MINUTES, and SECONDS on Page 10:

TO_CHAR(EXTRACT(DAY FROM MY_INTERVAL_COL)) AS MY_DAYS,
TO_CHAR(EXTRACT(HOUR FROM MY_INTERVAL_COL)) AS MY_HOURS,
TO_CHAR(EXTRACT(MINUTE FROM MY_INTERVAL_COL)) AS MY_MINUTES,

However, the Automated Row Fetch process appears to ignore columns of type INTERVAL DAYS TO SECONDS on Page 20.

:P20_INTERVAL (database column MY_INTERVAL_COL is used)
:P20_DAYS (trying to convert :P20_INTERVAL using TO_CHAR(EXTRACT(DAY...
:P20_HOURS (and so on...)
:P20_MINUTES

Does Automated Row Fetch ignore columns of type INTERVAL DAYS TO SECONDS?

Oracle 11gR2 used. Apex 4.1

Tim.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2013
Added on May 27 2013
8 comments
2,243 views