Hi,
i use PL/SQL Developer 7.0.1.1066 but also tried it with the trial of the newest version available from the website.
When i try to open the source of a view by right clicking on it and choosing "edit". The session seems to freeze. When i look at the session window with another pl/sql developer instance i see that the session is executing an "select * from my_view" statement on the view where i wanted to open the source. This takes a very long time because the view can only be accessed quickly when using an where clause in the statement.
Where does this behavior come from ? I think it must be an PL/SQL Developer Bug because it doesn't happen when using the Oracle SQL Developer.
We are just experiencing this when using Oracle Database 10g 10.2.0.4 on our old Database 8i 8.1.7.4 all works well.
Does someone have a solution for this or is it simply a bug ?
Thanks
Himmi
i use PL/SQL Developer 7.0.1.1066 but also tried it with the trial of the newest version available from the website.
When i try to open the source of a view by right clicking on it and choosing "edit". The session seems to freeze. When i look at the session window with another pl/sql developer instance i see that the session is executing an "select * from my_view" statement on the view where i wanted to open the source. This takes a very long time because the view can only be accessed quickly when using an where clause in the statement.
Where does this behavior come from ? I think it must be an PL/SQL Developer Bug because it doesn't happen when using the Oracle SQL Developer.
We are just experiencing this when using Oracle Database 10g 10.2.0.4 on our old Database 8i 8.1.7.4 all works well.
Does someone have a solution for this or is it simply a bug ?
Thanks
Himmi
