Hi,
I'm a student and I had to make a simple APEX application.
This is a part of the modelisation about the project :
As you can see, I have two "n-n" relation and one "1-n".
I want to create a page for the user in order to let him add an "oeuvre" (artwork) but this "object" had to be linked with "n" Genre (type), "n" Person and "n" exemplary.
I'm currently working on this page :
As you can see I have two list manager.
I try a simple test :
If I click on the "region button with dynamic action" called Click me! a short javascript code show me the content of the second list manager
id_personne = $v("P13_PERSONNE");
alert(id_personne);
the result looks like "40:30:4:6"
I want to be able in PL/SQL but I don't know how to do that :
- Get the value of the list manager (like javascript)
- Get each number of "40:30:4:6" in a LOOP
Currently my PL/SQL looks like :
DECLARE
v\_personne VARCHAR2(40) := '3:42:22:4:1:5';
v\_cptr NUMBER;
LN$I pls\_integer := 0;
BEGIN
v\_cptr := regexp\_count( v\_personne, ':' );
LOOP
LN$I := LN$I + 1 ;
dbms\_output.put\_line( to\_char( LN$I) ) ;
exit when LN$I >= v\_cptr ;
END LOOP;
END;
/
I'm just counting the number of ":" for the loop.
Kind regard