Problem with sql editor is back after new release

fidelfs

Member³
Version 11.0.5.1790 64 bit 01.100277

When I open a new sql editor and create different dmls pl SQL DEVELOPER only recognizes the first dml.

I can see multiple inserts, selects, etc, but If I try to save the editor (file save) the file contains only the first dml.

I tried to copy and paste inside the editor and only copies the first dml.

I tried to copy and paste to other editor outside PL Sql developer and only copies the first dml.

I tried to cut and paste to other editor outside PL Sql developer an d only copies the first dml.

I tried to insert a new line at the top of the editor and created a new DDL and tried to execute only that one. I placed the cursor on that line (DDL) and the DDl is executed.

The problem is only with the dmls.

I even tried the plugin execute current statement and also failed. The reason it failed is that the lines don't exist even are displayed on the editor. The current state of the editor is not the same of what is displayed.

I just copied below what I was testing. As you can see it copies only 2 lines, even thou I have on the editor about 10 more inserts and selects.

CREATE TABLE fidel_char3 (f2 VARCHAR2(10));
INSERT INTO fidel_char2 VALUES ('222');
 
Last edited:
I tried to find a pattern, but the only thing that makes it happen is this:

Open a fresh new instance of PL/SQL developer
Open a new sql editor
Make a DDL (i.e. create a table).
leave an open line
type insert into the new table values .... ;
select and copy the insert line.
pasted several times.
change the values on the inserts.

I have the autoselect option so I position my cursor in each line and press execute.

leave a blank line.
type a select statement to display the results.
PL/SQL developer show the message that one row was inserted.
That means is only seeing the first DML.

This happen random, so I know how it behaves when it happens, but I cannot make it happen at will.

It is a little scary, because you might be developing some queries and you think you will be able to save the file. The result will be a lost of lines and work.
 
Back
Top