6 Replies Latest reply: Oct 13, 2013 9:26 PM by swesley_perth RSS

    htmldb_item.select_list_from_query_xl

    vk

      Hi,

       

      I m using Oracle 11g, Apex version 4.0.2

       

      Recently, i found a problem in my application.

       

      I m having a report returning the values based on the query ex. as of below.

       

      'SELECT htmldb_item.select_list_from_query_xl(1,'SELECT value1 d, value2 r from table1',null,'No') ,

                    'Edit'

      from table2'

       

      The selectlist returns three values.

      'Edit' field has been linked to a page by passing this 'select list' value as a 'request' value

       

      But, the Select list is returning all the three values as a request value to the next page item.

       

      How it can be resolved?

       

      Regards,

      vk.