I/O error 123 when using "compare user objects" with EZNames

[Frank Schmitt]

Hi!

PL/SQL Developer doesn't handle EZNames correctly when comparing user objects between databases, resulting in I/O error 123.

Reproduce

• Tools -> compare user objects
• Enter a Oracle EZName for the target connection, e. examplehost123:1521/exampledb, and connect
• Start the comparison
• Select one object from the differences list, and press the "Show differences" button

This leads to an I/O error 123.

Cause
PL/SQL developer tries to create a temp file with the name examplehost123:1521\exampledb.txt

Proposed fix
Replace all non-alphanumeric characters in the filename by underscores or sth similar.

Kind regards
Frank

 

[Marco Kalter]

Which PL/SQL Developer version are you using?

 

[Frank Schmitt]

PL/SQL Developer
Version 7.1.1.1350

Kind regards
Frank

 

[Marco Kalter]

Thanks. We'll check it out and will fix it.

 

[andyh]

Originally posted by Frank Schmitt:
Hi!

PL/SQL Developer doesn't handle EZNames correctly when comparing user objects between databases, resulting in I/O error 123.

... snip ...

Correct, this is a long term feature, see my post http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=003664;p=1#000000 from last October where I report the same problem.