how can i enable a button to trigger a pl/sql insert action on click in an apex pl/sql dynamic conte

User_G4ALZ

i have this form i made with htp.p('');

htp.p('
<form>
<select multiple width="100%" style="width: 100%; height: 80%;">   
  ');
for a in 
(select id_plan, year_plan from plan)
loop
  htp.p('
<option value="'||htf.escape_sc(a.id_plan)||'">'||htf.escape_sc(a.year_plan)||'</option> 
end loop;
htp.p('</select>
<input type="submit" value="Submit">
</form>
');

i want to execute a pl/sql insert or update action when the form button is clicked.

is that possible ?

if so how?

fac586

Please update your forum profile with a recognisable username instead of "User_G4ALZ".

i have this form i made with htp.p('');

htp.p('
<form>
<select multiple width="100%" style="width: 100%; height: 80%;">   
  ');
for a in 
(select id_plan, year_plan from plan)
loop
  htp.p('
<option value="'||htf.escape_sc(a.id_plan)||'">'||htf.escape_sc(a.year_plan)||'</option> 
end loop;
htp.p('</select>
<input type="submit" value="Submit">
</form>
');

i want to execute a pl/sql insert or update action when the form button is clicked.

is that possible ?

No. This is not how APEX works. Specifically, HTML does not allow form elements to be nested, and every APEX page is essentially rendered as one long form.

What problem are you actually trying to solve? This requirement would normally be implemented declaratively using APEX page items, buttons, and LOVs.

fac586

my problem is that i have a very long list which is divided into groups, multiple level of groups (parent, sub_parent, sub_sub_parent..., child, sub_child) . i wanted to do so with the <optgroup> html tag but now since it is not possible i'm gonna have to work with 'select list' type of item in apex with only one parent group unless someone has another solution

From an accessibility and usability perspective select list controls are not suited to display of "very long lists". 100 to 200 entries should be considered the absolute maximum. Nor is optgroup of much help in structuring complex hierarchical data as it only supports one level of nesting.

From the limited information provided, the most obvious native possibility in APEX would be a Popup LOV. Alternatively a tree or report could be implemented on a pop-up dialog page to provide a selection UI. Consider an interactive grid with Oracle Text support and scrolling for faster searching and navigation, or a classic report with a custom template to reflect the structure of the data.

A plug-in could be another potential solution.

If you want more specific help then we would need the requirement defined in much more detail.

Awais Majeed

you can call JavaScript function to enable / disable button in htp.p code like

htp.p('function disp_alert()');

Regards

Awais Majeed

fac586

Please update your forum profile with a recognisable username instead of "User_G4ALZ".

i have this form i made with htp.p('');

htp.p('
<form>
<select multiple width="100%" style="width: 100%; height: 80%;">   
  ');
for a in 
(select id_plan, year_plan from plan)
loop
  htp.p('
<option value="'||htf.escape_sc(a.id_plan)||'">'||htf.escape_sc(a.year_plan)||'</option> 
end loop;
htp.p('</select>
<input type="submit" value="Submit">
</form>
');

i want to execute a pl/sql insert or update action when the form button is clicked.

is that possible ?

No. This is not how APEX works. Specifically, HTML does not allow form elements to be nested, and every APEX page is essentially rendered as one long form.

What problem are you actually trying to solve? This requirement would normally be implemented declaratively using APEX page items, buttons, and LOVs.

User_G4ALZ

https://community.oracle.com/tech/developers/discussion/comment/16780181#Comment_16780181

thank you sir for the explanation.

my problem is that i have a very long list which is divided into groups, multiple level of groups (parent, sub_parent, sub_sub_parent..., child, sub_child) . i wanted to do so with the <optgroup> html tag but now since it is not possible i'm gonna have to work with 'select list' type of item in apex with only one parent group unless someone has another solution

fac586

my problem is that i have a very long list which is divided into groups, multiple level of groups (parent, sub_parent, sub_sub_parent..., child, sub_child) . i wanted to do so with the <optgroup> html tag but now since it is not possible i'm gonna have to work with 'select list' type of item in apex with only one parent group unless someone has another solution

From an accessibility and usability perspective select list controls are not suited to display of "very long lists". 100 to 200 entries should be considered the absolute maximum. Nor is optgroup of much help in structuring complex hierarchical data as it only supports one level of nesting.

From the limited information provided, the most obvious native possibility in APEX would be a Popup LOV. Alternatively a tree or report could be implemented on a pop-up dialog page to provide a selection UI. Consider an interactive grid with Oracle Text support and scrolling for faster searching and navigation, or a classic report with a custom template to reflect the structure of the data.

A plug-in could be another potential solution.

If you want more specific help then we would need the requirement defined in much more detail.

jariola

@fac586 , link you provided to apex.world give session state violation error.

User_G4ALZ

https://community.oracle.com/tech/developers/discussion/comment/16780191#Comment_16780191

thanks again for your explanation i will look into that.

and since you asked for more explanation i could probably simplify my problem like this:

is there a way to make a collapsible list: you open the upper title to find different objects, you open one of those objects to find more objects (tree structure) until you reach the last selectable object which you can then check or uncheck (a multi select list is required).

i am new to APEX that's why i tried to find an html/javascript/plsql solution, if you know how i'd be very thankful and if not then i will just stick to your original solution with multiple select list .