Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
PL/SQL Developer Jump to new posts
Re: Grid Enhancement Request Marco Kalter 07/08/25 08:20 AM
I I have added this to the list of enhancement requests.

We'll fix the Ctrl-A issue as well.
1 46 Read More
PL/SQL Developer Jump to new posts
Re: PLSQL developer slow startup when in VPN Marco Kalter 07/08/25 08:08 AM
We will look into this and optimize if possible. It can also be that the Oracle Client Library is performing these operations, in which case it is most likely not possible to optimize this. We will find out and I will post the results here.
1 43 Read More
PL/SQL Developer Jump to new posts
Re: Missing features in v16 Marco Kalter 07/07/25 09:17 AM
Quote
I can't find the option to get multiple tabs in more than one row. I thought the setting User Interface/Options/use multi-row tabs was for that but that doesn't seem to do anything. I'm very much missing the overview when I have more tabs open than one line of tabs can hold.
For the window tabs this option is indeed no longer available.

Quote
Is there a way to disable the lint? There was in previous versions. Due to some impairments, I need access through the keyboard very much, but with the lint, this is pretty cumbersome (yes I found the option to enable the alt key anyway - why would someone want to disable that???).
You can go to Preferences > User Interface > Appearance and click on the "Switch to Menu" button.

Quote
Also, when I alt-tab to another application, the shortcut letters stay visible in that application which is pretty annoying. I have to restart PL/SQL developer to get rid of that, and after some time it happens again.
This will be fixed with the "Switch to Menu" option as well.
1 60 Read More
PL/SQL Developer Jump to new posts
Re: Code Assistant Displaying Invalid Results Marco Kalter 07/07/25 09:10 AM
We'll fix it!
1 81 Read More
PL/SQL Developer Jump to new posts
Re: Suggestion: Transform selected text in editor with (package) function call? Marco Kalter 07/04/25 02:28 PM
The 2 variables for the same package constant will be fixed in the next release:

Quote
I noticed that the bind variables names are the same as the PL/SQL Variable names, except when they are prefixed with the package name. We'll enhance this and will translate package.variable to :package_variable if possible.
4 216 Read More
PL/SQL Developer Jump to new posts
Re: Ctrl-Backspace bugs with multiple carets Marco Kalter 07/04/25 08:29 AM
Bug 1 and 2: I can indeed reproduce this. We'll fix it.

We'll also look into bug 3.
1 108 Read More
PL/SQL Developer Jump to new posts
Re: multi-caret editing Marco Kalter 07/03/25 08:29 AM
We'll fix it.
3 210 Read More
PL/SQL Developer Jump to new posts
Re: Are licenses time-limited? Marco Kalter 07/03/25 08:27 AM
Quote
1. Will I receive all upgrades for subsequent versions in dies 2 years

You will receive updates for the purchased version (e.g. 16.0.x). For major upgrades (e.g. 16.0 -> 17.0) you can purchase an upgrade after the new version is released.

Quote
2. my current version 16.xx would then be usable indefinitely, regardless of the length of the support contract.

That is correct. Licenses are perpetual.

Quote
3.If the customer later purchases an upgrade license (16.xx --> 18.xx), do all installations have to be upgraded to this version?

No, you are completely free to use any previous version.
1 162 Read More
PL/SQL Developer Jump to new posts
Re: Drag Tab between two instances Marco Kalter 07/01/25 09:01 AM
This is currently not possible. I have added this to the list of enhancement requests.
1 125 Read More
PL/SQL Developer Jump to new posts
Re: PLSQLD Keep opening closed windows on exit Marco Kalter 07/01/25 09:01 AM
Can you go to Preferences > User Interface > Options and disable the "Autosave Desktop" option?
1 132 Read More
PL/SQL Developer Jump to new posts
Re: Enhancement : Query By Example at multiple tabs at the same time Marco Kalter 06/30/25 08:40 AM
I have added this to the list of enhancement requests as well.
3 200 Read More
PL/SQL Developer Jump to new posts
Re: Finding View Errors Marco Kalter 06/26/25 08:52 AM
Thanks! At the moment you will indeed not get a warning or error message. We'll fix this.

The "Compile Invalid Objects" tool will include the invalid view, will display the errors, and will allow you to recompile it.

We'll enhance the SQL Window to show the error as well.
3 205 Read More
PL/SQL Developer Jump to new posts
Re: Enhancement: Changing table's constraint Marco Kalter 06/25/25 08:21 AM
I have added this to the list of enhancement requests.
1 119 Read More
PL/SQL Developer Jump to new posts
Re: How to use global cursor variable in test script? Marco Kalter 06/24/25 08:05 AM
You cannot use global cursor variables. Cursors can only be used in the context of a single Test Script, so you would have to combine them.
1 121 Read More
PL/SQL Developer Jump to new posts
Re: Templates Auto Focus Benjamin L 06/20/25 05:39 AM
Works great. Thx a lot for the quick fix Marco, this makes a lot of me and my colleagues happy!
5 449 Read More
PL/SQL Developer Jump to new posts
Re: Editing field in Single Record View move cursor at position 1 DLGL 06/19/25 09:04 PM
The corrective works well.

Thank you a lot !
5 335 Read More
PL/SQL Developer Jump to new posts
Re: Mouse hung as busy D.Wenzel 06/18/25 05:23 AM
Moin Marco,

thx .. fixxed in 16.0.5.2166

Ahoi D.

/close
4 368 Read More
PL/SQL Developer Jump to new posts
Re: Problems with Code Folding TenGor 06/17/25 12:43 PM
The same problem occurs, if you delete a lot of line of code...
3 188 Read More
PL/SQL Developer Jump to new posts
Re: Problems with Linked Query in SQL-Window TenGor 06/17/25 08:47 AM
Thanks.
2 153 Read More
PL/SQL Developer Jump to new posts
Re: Increase Speed when multiline editing in SQL file D.Wenzel 06/17/25 06:30 AM
@Zitot - we made a "private" version for the canames.sql
the ALL_* data-dictionarty views ar a slow downer in our dev-environment


We..
* have many, many synonms but
* can use DBA_* data-dictionarty views but
* must also downgrade the optimizer frown
* and also a NO_PARALLEL hint to avoid unwanted parallel sql made by the db


D.

SQL Query
/*
  The name + type results of these queries will be used by the Code Assistant
  if the "Describe Context" option is enabled. After typing 3 or more characters
  the Code Assistant will show a list of matching names.
  Separate multiple queries with semi-colons and use the :schema bind variable
  to restrict names to the currently connected user. 
  In case of an error the query results will be omitted. No error message will
  be displayed.
  Place this file in the PL/SQL Developer installation directory for all users,
  or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select /*+ optimizer_features_enable('9.2.0') no_parallel*/ object_name, object_type
  from sys.dba_objects o
 where o.owner = :schema
   and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
;
select /*+ optimizer_features_enable('9.2.0') no_parallel*/ object_name, object_type
  from (select  connect_by_root(synonym_name) object_name, a.object_type
          from sys.dba_synonyms s
           CROSS JOIN LATERAL (select o.object_type
                  from sys.dba_objects o
                 where 1 = 1
                   and s.table_owner = o.owner
                   and s.table_name = o.object_name
                   and o.object_type in ('TABLE',
                                         'VIEW',
                                         'PACKAGE',
                                         'TYPE',
                                         'PROCEDURE',
                                         'FUNCTION',
                                         'SEQUENCE')  ) a
         where 1 = 1
           and connect_by_isleaf = 1
           and connect_by_iscycle = 0
         start with s.owner in ('PUBLIC', USER)
        connect by nocycle s.owner = prior s.table_owner
               and s.synonym_name = prior s.table_name)
 where 1 = 1
   and object_type is not null
;
select /*+ optimizer_features_enable('9.2.0') no_parallel*/ db_link as object_name, 'DATABASE LINK' as object_type
  from sys.dba_db_links o
  where o.owner = :schema
     or o.owner = 'PUBLIC'
;
3 253 Read More
PL/SQL Developer Jump to new posts
Re: Right/Left Arrow keys and Caret Behavior on Windows zitot 06/16/25 10:27 PM
Sorry, uploaded wrong file.

I've attached a gif showing the bug get triggered.

[Linked Image from i.postimg.cc]
Steps to recreate:
1. Multiselect last letter of two words.
2. Hit Ctrl+Backspace

Although in the video I typed some text and hit Ctrl+Backspace and only deleted first letter, the other day it seems to also occur even when the user selects last letters, hits ctrl+Backspace, and it deletes both the selected letter and the first letter of the preceding word.

This has an element of luck in it as far as reproducing it goes.
3 227 Read More
PL/SQL Developer Jump to new posts
Re: Accessing objects from another schema Lukasz Indeka 06/13/25 10:39 AM
You're right. My idea was that if I prepend test_view with the userB schema name, then PL/SQL Developer should see objects like I was logged in with userB privileges. When I thought about it again, this is a very bad idea.
2 216 Read More
PL/SQL Developer Jump to new posts
Re: Problems with compilation of a large view CoffeeK1d 06/12/25 12:46 PM
I have run into multiple compile bugs and ultimately settled on calling DBMS_UTILITY.COMPILE_SCHEMA and then loop through invalid objects to execute the alter <object> compile. This process addressed our main issue with being unable to recompile procs using macros even when they didn't change and were completely valid.


SQL Query
CREATE OR REPLACE PROCEDURE FOO.SP_RECOMPILE_OBJECTS
AS
BEGIN
    BEGIN
        DBMS_UTILITY.COMPILE_SCHEMA(schema => 'VAL', compile_all => FALSE);
        DBMS_UTILITY.COMPILE_SCHEMA(schema => 'APP', compile_all => TRUE);
        DBMS_UTILITY.COMPILE_SCHEMA(schema => 'CC', compile_all => TRUE);
    END;

    BEGIN
        FOR cur_rec IN (
            SELECT
                owner
               ,object_name
               ,object_type
            FROM dba_objects
            WHERE status = 'INVALID'
              AND owner IN ('CC')
              AND object_type = 'PROCEDURE'
            ORDER BY object_type
                ,owner
                ,object_name
        )
        LOOP
            BEGIN
                EXECUTE IMMEDIATE 'ALTER ' || cur_rec.object_type || ' ' || cur_rec.owner || '.' || cur_rec.object_name || ' COMPILE';
            EXCEPTION
                WHEN OTHERS THEN
                    DBMS_OUTPUT.put_line('EXCEPTION : ' || cur_rec.owner || ' : ' || cur_rec.object_name);
            END;
        END LOOP;
    END;

END SP_RECOMPILE_OBJECTS;
/
2 180 Read More
PL/SQL Developer Jump to new posts
Re: Problems with Version Control in PL/SQLDev. TenGor 06/11/25 05:56 AM
If i use the popup "Shell" in the File Browser then i get the installed language of TortoiseSVN.
In the popup "TortoiseSVN" in the File Browser i only get the default languate
3 174 Read More
PL/SQL Developer Jump to new posts
Re: Beautifier and Views with PL/SQL functions in the with clause Marco Kalter 06/10/25 08:54 AM
Thanks. We'll try to fix it.
3 169 Read More
Page 1 of 2 1 2
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.195s Queries: 6 (0.083s) Memory: 2.3535 MB (Peak: 2.4252 MB) Data Comp: Off Server Time: 2025-07-09 08:41:44 UTC
Valid HTML 5 and Valid CSS