1 Reply Latest reply: Dec 21, 2012 3:30 AM by fac586 RSS

    Multiple select lists in tabular form

    LnTInfotech
      Hi,

      I created a tabular form with two select lists (Queries are same for both the select list and results around 300 records in the SQL).
      I am getting the following error:

      report error:
      ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      If I changed Select list to POP list, I am not getting error.

      Please suggest how to user select list in this case.

      Regards,
      Meda
        • 1. Re: Multiple select lists in tabular form
          fac586
          LnTInfotech wrote:

          I created a tabular form with two select lists (Queries are same for both the select list and results around 300 records in the SQL).
          I am getting the following error:

          report error:
          ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

          If I changed Select list to POP list, I am not getting error.

          Please suggest how to user select list in this case.
          It is not possible. There is a 32K limit on the HTML generated for select list items. (As a type of report, tabular forms are also subject to the 32K limit on the size of a report row.)

          In terms of usability 200 options is about the maximum size I would consider sensible for a select list ( and for select lists in tabular forms, much, much fewer!)

          Use Popup Key LOVs.