Select with Submit - ORA-01722: invalid number performing List of Values
TimCSep 27 2006 — edited Sep 27 2006Hi,
I am on Apex 2.0.0.00.49.
I have a series of Selects with submits. When select #1 is selected, that is when I want the LOV entries in select #2 to show up. And then when 2 is selected, i want number 3 to have values to choose from. But until the parent select is chosen, I want the entry to be there and have no entries.
Everything is fine first time in. All select lists except for the first one is blank. Then I pick first lov and it submits. List 2 gets values based on list 1 so all good. Except that all the following select lists now have:
ORA-01722: invalid number performing List of Values
The error is to the right of the label in the place of the select list.
I am defining the LOV in the actual select with submit item (not using a named LOV).
Thanks,
Tim