code assistant problem

[coolboy0518]

hi, i'm a new to PL/SQL and i have a WIN XP Professional on my laptop, my PL/SQL is 6.0.4.906.

i met a problem which my workmates never met.

I type in the following:
select * from oe_order_headers_all oh,
oe_order_lines_all ol
where ol.header_id=oh.header_id
and ol.line_id=3024

when I type in "ol.", it will wait a long time for code assistant list the colomn, and then for "oh.".
and I type in the secend "ol.", i must wait again.

it also happened when i use functions. when i type in "(" after function, such as NVL, I also will wait a long time before code assistant display the parameters.

Does anyone meet the same problem? how can i settle it down?

thanks

 

[bibi]

i have also other problem with the code assitant.
when i type an sql with an order by of a date field
i cant see the field in the drop down list

 

[Marco Kalter]

when I type in "ol.", it will wait a long time for code assistant list the colomn, and then for "oh.". and I type in the secend "ol.", i must wait again.

The Code Assistant will query the Oracle Dictionary to describe objects. Maybe there is a performance problem with your dictionary views? In any case, you can go to Tools > Preferences > Code Assistant and disable the "Automaically activated" option. Now you explicitly need to press F6 to activate the Code Assistant, which may eleviate the delay problem.

i have also other problem with the code assitant.
when i type an sql with an order by of a date field
i cant see the field in the drop down list

Can you send me the SQL text?

 

[coolboy0518]

yes, Marco! I just do it as your opinion. but I still must wait after press F6.
have you ever tested on WINXP professional? other guys around me never meet this problem. and when i use WINXP home, it also runs well.

 

[bibi]

sorry , my mistake, i cant see any field in the fields list after pressing F6
i see only function , tables, ...
and it's not only after the order by clause, it's everywhere.
however it will work ok if u add an alias to the table name
for example :

select * from table t order by t.field

 

[Marco Kalter]

have you ever tested on WINXP professional?

Yes, this is our primary development and test platform. It's not OS dependant, and my guess is that this is a local Oracle Client issue.

however it will work ok if u add an alias to the table name

That is indeed how it works. You will only get a field list after an alias.

 

[coolboy0518]

hi, Marco,
Do you have some tools which can check my Oracle Client?
I hope to find out the problem because it troubled me a lot.
thanks!

 

[Marco Kalter]

In PL/SQL Developer you can go to Help > Support Info and check for version differences on the Info tab page.

 

[F. van Boven]

Nice place to add another thing:

After calling the code assistant, it is possible to browse through the fields (Arrow up, Arrow down). After you do this, it is not possible to continue typing (Like in Delphi).

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[coolboy0518]

the following is the content of my info tab

Parameters
D:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
BEQ-LOCAL.WORLD
DEV
ERP2DEV
EXAMPLE1.WORLD
EXAMPLE2.WORLD
...

Homes
DEFAULT_HOME (d:\orant)
yexr_home (d:\yexr_home)

DLLs
d:\yexr_home\bin\oci.dll

TNS File
d:\yexr_home\Network\Admin\tnsnames.ora

Using
Home: yexr_home
DLL: d:\yexr_home\bin\oci.dll
OCI: Version 9.0
Oracle9i Enterprise Edition Release 9.2.0.3.0
Character size: 2 byte(s)

could you tell me the difference?
thanks.