Strange editor bug or Oracle bug!?

[DoDo]

While editing some old trigger wich never was changed after we migrated to 10gR2, i tried to select some part of triger by clicking on "if" in header of editor window (or in code), and result was: Selected portion was not what I was expecting (selected part starting from middle of previous block and trough middle of desired block)??? As I noticed, it only happens on some old triggers, but not in all of them.

Does anyone noticed similar behavior?

 

[Marco Kalter]

Can you let me know your PL/SQL Developer version and send me your trigger source file?

 

[DoDo]

Version 8.0.0.1480
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
OCI Library: C:\X\9i\bin\oci.dll

Security policy does not permit the delivery of trigger source.

The problem occurs also in other circumstances.

Possible causes:
1. Using latin characters in coments: šđč枊ĐČĆŽ
2. Using a colon, minus, points, etc. in coments

When I remove such characters, normal behavior returns.

Probably just some of the characters (or order of characters) affect the behavior that is manifested, but this was not case in the previous version 7, with exactly the same settings.

 

[Marco Kalter]

Can you create a dummy trigger source to reproduce this?

 

[DoDo]

Open new Program window (blank).
Paste:

Create Or Replace Trigger xxxxxxxxxx_yyyyyyyyyy
Before Insert Or Update Of some On some.table_1
For Each Row
Declare
/* V2 -halid de be šeued u horsoe nst am kibe muret balzte kiebap velauyr */
/* -ažbewca se sučrkia s odinfabimi */
e_neispravan exception;
Pragma exception_init (e_neispravan,-20001); -- Klufa kolisarit rumatak
Begin
Null;
End;

Click on "Pragma"
with mouse hover over "Comment"

 

[Marco Kalter]

This does indeed not seem to work correctly. We'll fix it.

 

[Claus Pedersen]

Also, when switching between the different window types, for instance shifting from Program window into Command window, the multibyte letters are translated wrongly. And three strange characters are inserted in the beginning of the code: ascii 239, 187, and 191.

 

[Marco Kalter]

We'll fix that too.