Recent content by Ivan C.

Is there a place were we could vote on enhancement requests? I would opt-in for this one too (don't have admin privs at my place, and the version used here is old).

A colleague of mine had a similar issue. He fixed it by disabling Clipboard History. In Preferences click on Editor option under User Interface section. In the right pane scroll down to the Clipboard section and uncheck Clipboard History.

Using Home: OraClient12Home1 DLL: C:\app\client\<username>\product.1.0\client_1\bin\oci.dll OCI: version 12.1 (12.1.0.1.0) Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 Except for the (obviously) exactly identical. Thank you for your suggestion. Was worth a shot.

Another member of my team, with the same version of PL/SQL Developer (12.0.7.1837, 64-bit), and similar machine (Windows 10 Pro), connecting to the same DB (Oracle Enterprise Edition Release 12.2.0.1.0 - 64bit, on Linux) is able to compile the code just fine, while I'm getting an error. I tried...

Whenever I start debugging a PL/SQL block with syntactical errors, the Test Window hangs for about 7-10 seconds, before returning the error. Example: begin for i in 1 ... 10 loop null; end loop; end; Once I hit F9 to start debugging, PSD hangs for several seconds, then shows the...

+ 1 for the referencing constraints list as an additional tab To get the list though, there's a workaround (sorta)... A Table object, in Object Browser, has a sub-folder called Foreign key references. If you expand it, it shows the list of FK constraints referencing the table in focus, with the...

Just ctrl+right-click the function name in the SQL Window. That'll open the package body in a new Program Window, while positioning the cursor on the beginning of function's code.

Version 12.0.7.1837 (64-bit) on Windows 10 Pro The examples by @frido (first post) still behave as reported (not fixed)

To reproduce 1. Connect to database. Note: in Preferences, under Connection, I have Session Mode set to Multi session, and I've unchecked Allow multiple connections; 2. Open a .sql script containing a function (the same happens to procedures or packages too). Function's name is prefixed with...

Furthermore, if we right-click on the synonym name (in SQL Window) and choose Drop, and not be careful what the pop-up says, or click the Don't show this message again, we'll be dropping the table, instead of synonyms.

We had a private synonym for a table. In order to navigate to the synonym in Object Browser from a SQL Window, I right-click synonym's name and chose Browse. However, that jumps to the table (in Object Browser), not to the synonym. If the developer is not careful, he may right-click the object...

I'm using the Test Window to call a function that returns a CLOB, which I store in a CLOB bind variable. Once the Test Window runs through, I open the CLOB in Large Data Editor, so I can save it locally. The text in the Text tab (and all others) looks correct, so I proceed by clicking on the...

Make sure you grant EXECUTE and DEBUG privileges to the "executing" user too: grant execute, debug on . to ;

PL/SQL Developer version 12.0.4.1826. Open package DBMS_UTILITY spec: 1. type uncl_array is missing in Code Contents tree; 2. directive $error shows as a variable; 3. declaration of second procedure validate is incorrectly rendered (variable null appears in Code Contents tree as a result).

I experience the same issue, most of the time, when debugging "huge" PL/SQL packages. Unfortunately, same as Jens, I cannot publish the code either (many table/code dependencies too). But the issue persists. In fact, the issue is not only with breakpoints. After compiling previously debugged...