Debugging a block with syntax error slow to start

[Ivan C.]

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 error pop-up.
If the code has no syntactical errors, the debugging starts right away.

Info:
PSD v12.0.7.1837 (64-bit) on Windows 10 Pro, connected to Oracle 12c Enterprise Edition Release 12.2.0.1.0 - 64bit, on Linux

 

[Marco Kalter]

I can indeed see a similar delay on Oracle Server 12.1 and 12.2. On Oracle Server 11.2 and earlier it is much faster. We'll investigate.

 

[Benjamin L]

It's the same Problem i reported inhttps://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=56097#Post56097

But this is not a Oracle 12 Problem, i tested this with PSD 11.0.6.1796 vs. PSD 12.0.7.1837 on
- Oracle Database 11g Release 11.2.0.4.0
- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0

In any case PSD 11.xx disn't need more than 2 seconds for error result, while PSD 12.XX needed about 10-15 seconds for error results

 

[Benjamin L]

Hi Marco,

it seems this problem has returned.

I have checked this with different Oracle Versions (19.0.0.0.0, 12.2.0.1.0, 11.2.0.4.0).

All with PL/SQL Developer Version 14.0.5.1986 (64 bit)

Best regards benjamin

 

[Benjamin L]

Any news on this?

 

[Marco Kalter]

I'm afraid there is no news. On Oracle 11.1 and later there is a small delay of 1-2 seconds. On Oracle 10.2 there is a significant delay of about 15 seconds. It does not seem that we can do anything about this.