Test window: method using CLOB 'translates' content to Chinese (?)

[Claus Pedersen]

I have the following procedure:

CREATE OR REPLACE PROCEDURE tester (input IN CLOB) IS
BEGIN
  IF dbms_lob.substr (input, 1, 1) != 'x' THEN
    NULL;
  END IF;
END tester;

I make a test script by rightclicking on the procedure, change the type from CLOB to Temporary CLOB (otherwise the CLOB can not be read in the test script, an old error), enter data in the clob and press F8. Now the data in the clob is translated into Chinese or Japanese or ???
(sorry to people in China and Japan, that I do not read your language)

Please fix this.

 

[Marco Kalter]

I cannot reproduce this. Maybe this is an environment problem. Can you go to Help > Support Info and send me the text from the "Info" tab page?

 

[Claus Pedersen]

From Info tab:

PL/SQL Developer
Version 13.0.0.1873 Beta (64 bit)
Windows 10 Build 17134

Physical memory : 8.078.112 kB (4.334.540 available)
Paging file : 9.388.832 kB (3.187.464 available)
Virtual memory : 137.438.953.344 kB (137.434.216.732 available)

Parameters
C:\Program Files\PLSQL Developer 13 Beta\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: False

Preference Files
C:\Users\NN\AppData\Roaming\PLSQL Developer 13\Preferences\default\Default.ini
C:\Users\NN\AppData\Roaming\PLSQL Developer 13\Preferences\NN\default.ini

Debug file
C:\Users\NN\AppData\Roaming\PLSQL Developer 13\PlSqlDev.elf

Plug-Ins

Aliases
ora11
ora12
XE

Homes
OraClient12Home1 (c:\oracle\product\12.1.0\client_1)
XE (C:\oracle\product\xe\app\oracle\product\11.2.0\server)

DLLs
c:\oracle\product\12.1.0\client_1\bin\oci.dll

TNS File
c:\oracle\product\12.1.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient12Home1
DLL: c:\oracle\product\12.1.0\client_1\bin\oci.dll
OCI: version 12.1 (12.1.0.2.0)
Oracle Database 11g Express Edition Release 11.2.0.2.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

Process
Working Set = 89.583.616
Memory = 47.443.674
GDI Objects = 1470
User Objects = 881
Handles = 729

Monitors
PixelsPerInch = 96

Id = 0
PPI = 96
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1200

Id = 1
PPI = 96
Primary = False
Handle = 65539
Left = -1680
Top = 0
Width = 1680
Height = 1050

 

[Marco Kalter]

Thanks. We were able to reproduce the issue and will fix it.

 

[Claus Pedersen]

Super, thanks

 

[Claus Pedersen]

Seems to be solved in beta 5