Oracle Apex Radio Button

Question

I have a radio group with static values : A;1,B;2,C;3 . 1,2,3 are values from the column company where A,B,C belong .

This is my SQL query .

    Select  company into :p2_type from table where orderno = 
    :p2_orderno and rownum = 1;

This is a part of page 1 & 2 which are linked together . I don't see a selected radio group when I move on to the next page although I see the orderno move over . I created a process in page 1 so that it runs this query when I click the 'next' button which also redirects me to the next page which is 2 .

Answer 1

This is what I did . I changed the radio type to a select list . I still had the static values defined as A;1,B;2,C;3 . Now when I select A or B or C and hit submit (I have linked the insert into column SQL to the submit button) it populates the table with a 1 or 2 or 3 . So my task has been accomplished but not in the way I wanted it to .