Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

4.0EA1 - "Find Database Objects" Results: All Source Lines - Grouping and Order Problem

David VJul 23 2013 — edited Jul 24 2013

In 4.0 EA 1, when using the Find Database Object feature to search "All Source Lines", SQL Developer sorts the results by the text of the source code line, before it sorts by the object name the source code line is actually in. In certain scenarios, this causes the same object to actually show up multiple times in the results, but not grouped together.

To reproduce, create two objects in the same schema:

CREATE OR REPLACE PROCEDURE my_proc AS

  v_MyVar NUMBER(8, 4);

BEGIN

  v_MyVar := 1234.5678;

END;

/

CREATE OR REPLACE PROCEDURE my_other_proc AS

  v_AVar  NUMBER(8, 4);

  v_ZVar  NUMBER(8, 4);

BEGIN

  v_ZVar := 1234.5678;

  v_AVar := 1234.5678;

 

  -- Some comment.

 

  v_AVar := 0;

END;

/

Then, search that schema for the value "1234.5678." In the search results, the "MY_OTHER_PROC" procedure will be listed twice, instead of being grouped together like it should be.

Related to this bug also, the result lines within the same object are shown in alphabetic order, rather than in numeric line order (i.e. the same order they are within the object). To see this, search for "v_AVar" - in the results, you'll see that the result found on line 10 precedes the result found on line 6 of MY_OTHER_PROC. This doesn't make sense - it seems like the results should be in the same order they are within the source, rather than alphabetic by line text.

Thanks for your attention.

Comments

Eric.Sacramento

User Interface Details

2019-04-29_9-34-34.png

User_EI49E

When I change 101 to LOGIN_DESKTOP I get

Sorry, this page isn't available

Application "30101" Page "LOGIN_DESKTOP" not found.

Contact your application administrator.

Eric.Sacramento

you probably deleted this pages, create another application and copy this page to your application.

User_EI49E

Yes, I deleted the new login page, but not the original 101. How do I set LOGIN_DESKTOP back to 101. Is that an application item? Thanks.

Pete

Eric.Sacramento

in the image that I sent to you, try to replace LOGIN_DESKTOP for the number of the page that you want

Neil Clare
Answer

LOGIN_DESKTOP is an alias to your login page.

When you create a new application (or new scheme) the logon page is automatically given that alias.

If you manually delete the page, then the alias does not point to anything.

All you have to do is manually add the alias back in to your original login page.

Capture.PNG

Marked as Answer by User_EI49E · Sep 27 2020
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 21 2013
Added on Jul 23 2013
1 comment
336 views