Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 387 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Returning values from a PL/SQL DA into Multiple Selects Lists Itens with Cascading Lov Parent

Oh, Huge title!
Ok folks, I'm having some trouble with Select List Item and DA.
Example:
Dynamic Action: when change item P1_A is not null
Execute PL/SQL:
begin
select b,c
into :P1_B, :P1_C
from table
where field = :P1_A ;
end;
------------------------------------------------------------------------------------------
The fields P1_A, P1_B , P1_C are Select List Itens;
The fields P1_B , P1_C contains Cascading Lov Parent Itens;
- P1_B Cascading Lov Parent Itens: P1_A
- P1_C Cascading Lov Parent Itens: P1_A, P1_B.
Ok... The problem is...
When the DA is triggered, values from query into DA is returned on Field P1_B, but P1_C isn't...
Now, if manually selected P1_A value, then P1_B is refreshed, so I select P1_B value, then P1_C is refreshed, so there are values on P1_C to select.
That process is not working when is used Dynamic Action pl/sql.
I really don't know if it's something to fix on Oracle Apex or it's my fault.
Thank you.
Answers
-
Hard to tell what is wrong.
Please recreate the problem on http://apex.oracle.com/
Make sure you create a Developer account so that you don't have to post your email to the spam bots.
We need
workspace:
developer account:
password:
This way, we can see what you did and correct the code if necessary.
MK
-
select b,c into :P1_B, :P1_Cvalues from query into DA is returned on Field P1_B, but P1_C isn't...
Did you specify both items as Page Items To Return?
-
Hi InoL!
Yes, I did.
In my page, there is many others select lists that works with Dynamic Action returning datas from queries, only in this case is not working.
I'll try to recreate this case on apex.oracle.com.
Thank you