Code Assistant Pauses after column selection

[rbybee]

I am trying to determine why it takes about 10 seconds for the cursor to return to my query after using the code assistant to select a column for a view. Here is the select I am using:

select * from all_tab_columns c
where c.COLUMN_NAME

After I enter the period, the list of columns appears very quickly. Once I select the column, it takes about 10 seconds for the cursor to return with the column I selected. This problem does not occur when I am referencing a table instead of a view.

Any idea what causes this problem?

 

[Marco Kalter]

Can you disable the Code Assistant preference "Use original case if possible" and try again? My guess is that there is a problem obtaining the view source to get the original case.

 

[rbybee]

That was it. What does "Use original case if possible" do?

 

[Marco Kalter]

It fetches the source of the object that is described, and extracts the original name of the selected column/parameter from that source.

For example, consider the following view:

create or replace view Dept10 as
select EmpNo, EName, Sal from Emp where DeptNo=10

In the dictionary, the view columns are reported as EMPNO, ENAME, SAL. If you select EMPNO from the Code Assistant, then EmpNo will be inserted in the editor.