Error in substitution variable, List option

[Claus Pedersen]

1) Error: I have tried an example similar as the one supplied in the manual:

SELECT &<name="ID"
         list="10, ACCOUNTING,
               20, RESEARCH,
               30, SALES,
               40, OPERATIONS"
         description="yes">
FROM dual;

When executed I get the error: "Descriptive list requires even number of items ..."
When I collect all items in list on one line it works fine:

list="10, ACCOUNTING, 20, RESEARCH, 30, SALES, 40, OPERATIONS"

This is a small inconvenience I can learn to live with.

But when I change to code to:

SELECT &<name="ID"
         list = "10, ACCOUNTING,
                 20, RESEARCH,
                 30, SALES"
         description="yes">
FROM dual;

I get a strange result. Now the list can be evaluated, but shows the values:
ACCOUNTING
20

SALES

It seems the problem lies in the evaluation of the second line in the list when the list is 'formatted' with line breaks.

(I am using version 7.0.1.1066)

2) A small bug/feature: I can not select an item via a list with the keyboard if I do not want to execute the statement. If I use to select an item and move to the next parameter field, the previous field is left blank. If I use the mouse to click it works fine. An example is provided below:

SELECT *
FROM   user_tab_columns
WHERE  table_name=&<name="Tabl"
                    type=string
                    list="SELECT table_name
                            FROM user_tables">
AND    column_name=&<name="Column name"
                     type=string
                     list="SELECT column_name
                             FROM user_tab_columns
                            WHERE table_name = :tabl">;

Another strange behaviour: If use the reserved word 'table' in the name, name="table", and in the referenced name, :table, I am not able to move the cursor out of first field. Using other reserved words causes the same behaviour.

3) Request: Checkboxes are centered in the value column in the Variables pop-up window. Is this on purpose? If not, I suggest that they are placed left-aligned in the window.

 

[Marco Kalter]

We'll check it out and will fix it.

 

[Claus Pedersen]

Thank you, it is not a big issue, so don't rush it ...