Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Possible a bug from cascade select list

bsalvadorJan 15 2014 — edited Jan 16 2014

Hi people,

I created a dynamic action "onChange" in a page item called "P5_COD". Always "P5_COD" value changes, it executes PL/SQL code above to populate page items with data from database:

select

   PERIOD,

   BEGIN_DATE,

   FINISH_DATE

into

  :P5_PERIOD,

  :P5_BEGIN_DATE,

  :P5_FINISH_DATE

FROM ...

BEGIN_DATE and FINISH_DATE are "select list" page items. They are "Cascading LOV Parent Item(s)" from PERIOD (select list too).

The problem is: The "onChange" dynamic action doesn´t work to load BEGIN_DATE and FINISH_DATE page items.  BEGIN_DATE and FINISH_DATE load default data and not data from database.

Any idea?

Thanks,

Bsalvador
This post has been answered by Nicolette on Jan 16 2014
Jump to Answer

Comments

60437
Leigh - If you can put your application on apex.oracle.com, I will try it there and see what I can figure out. What version of Application Express are you using?

Scott
482478
Scott --

Thank you for the reply...We are currently using version 3.1.1.00.09 on an Oracle 10gR2 database. I will try to post the application to the hosted environment as requested, but it will be the first time I have done so, so be prepared for further questions...or if you guys have a document outlining the how's and "gotcha" that would be good too.

Thanks,
Leigh
482478
Scott --

I'm totally confused now....it usually doesn't take much especially on a Monday morning. I was able to export the three components without errors today. We have been seeing an extraordinarily high load on the system due to other testing and development going on. I'm wondering if the load issue may be related, though I don't see exactly how that could be.

Anyhow, I've attempted to upload my application to the hosted site numerous times now. It is a large application and is timing out during the install. I removed some of the pages and security functions, but it appears I probably removed too much, since I'm getting an Oracle error when installing now.

As the problem is intermittent, even in my environment, I'm going to guess that the issue isn't in APEX, but rather something in my environment.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 13 2014
Added on Jan 15 2014
#apex-discussions, #database, #from, #list, #load, #select
2 comments
258 views