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!

Child LOV issue

25631Oct 16 2011 — edited Oct 24 2011
Hi,

I am running into an issue and I hope I am just missing something obvious?
I have a Select List object which I want to base another Select List object off of i.e. cascading lov
This issue is in the second Select List object I am basing an LOV off of the parent Select List objects value.

Thus in my query I have
SELECT ename
  FROM emp
 WHERE deptno = :P2_DEPTNO
But it seems that the :P2_DEPTNO is not yet initialized or something because I always get null in my second
Select List object. But if I hardcode the :P2_DEPTNO to 10 it works fine.
Am I missing something here?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2011
Added on Oct 16 2011
16 comments
146 views