Compare Table Data bug?

[Roeland]

When using "Comparing Table Data" you have 2 modes:
-Generate Script
-Update Database

I have a problem with the latter.
Does anybody uses it?

On my side it's a disaster:
=> It freezes almost immediately (even on very small tables, say 1 record) and when killed messes up the table.
This behavior is very weird. When selecting from that table again on the target location freezes PL/SQL Developer completely.

I can repeat this behavior consistently with PL/SQL Developer version 8.0.4.1514 on Oracle 10.2.

TEST SETUP:

Test table:
CREATE TABLE TEST
(ID NUMBER(9,0) NOT NULL ENABLE,
ICON BLOB,
CONSTRAINT TEST_PK PRIMARY KEY (ID));

Create this table on the source and target DB

Source DB:
- Insert 1 record (with blob) into this table.
- Start "Compare Table Data", mode is "Update database"

=> Compare freezes
=> Kill it!

Target DB: Select from table "TEST"

=> PL/SQL Developer freezes

Roeland

 

[Marco Kalter]

Works fine for me. To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[Roeland]

Debug.txt is sent to support@allroundautomations.com

It seems to me that PL/SQL Developer gets into an unlimited loop...

Roeland

 

[Marco Kalter]

Thanks, we'll check it out.

 

[Roeland]

This bug is still reproducible in V9 beta1.

! This should be such an easy way to update lobs from 1 schema to the other, but alas, after all this time it still doesn't work !

When will it get fixed?

Setup:
------
Here goes it again:

CREATE TABLE TEST_BETA
 (ID NUMBER(9,0) NOT NULL ENABLE,
 ICON BLOB,
 CONSTRAINT TEST_BETA_PK PRIMARY KEY (ID));

Create this table in 2 schema's.

Add now a record to this table in 1 of the schema's.

insert into TEST_BETA
  (id, icon)
values
  (1, TO_BLOB(UTL_RAW.CAST_TO_RAW('hello world')));

commit;

Problem:
--------

1) Start now the "Compare table data" in the schema where you inserted the record. (Tools -> Compare table data..)
2) Select the "TEST_BETA" table. (PS: notice that typing the first letter to go there quick don't work...)
3) Choose the Target session and set it to the second schema.
4) Go to the "Options"-tab and set the MODE to "Update database"
5) Hit compare
6) Wait for eternity...

Roeland

 

[Roeland]

There has been some progression on this topic in V9 beta2.

1) Inserting records with blob's is working now. Thanks.
2) Updating still doesn't work. It doesn't hang anymore, but the resulting blob in the target scheme is something "different".

Thanks,

Roeland

PL SQL Developer 9.0.0.1592 Beta (2)

 

[Roeland]

Hi,

Things are becoming better and better.

1) Inserting and updating BLOB's are working now. Thanks.

But:
2) Inserting and updating CLOB's still don't work. The program hangs.

Roeland

PL SQL Developer 9.0.0.1593 Beta (3)
Oracle Client 11.2
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: DUTCH_BELGIUM.AL32UTF8
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Roeland]

This works as expected in PL/SQL Developer 9.0.0.1594 Beta (4)

Thanks,

Roeland