Displaying XMLType causes strange errors and disconnects

[djkucera]

I'm running PL/SQL Developer 6.0.6.946 against a 10.2.0.1.0 database.

Selecting an XMLType column in an SQL Window produces strange error messages and eventually disconnects.

To reproduce the error, run these statements one at a time in an SQL Window:

create global temporary table TEMP_XML
(
LINE NUMBER,
XML_BLOCK XMLTYPE
)
on commit preserve rows;

INSERT INTO temp_xml(line, xml_block)
VALUES (1, '')

INSERT INTO temp_xml(line, xml_block)
VALUES (2, '')

INSERT INTO temp_xml(line, xml_block)
VALUES (3, '')

SELECT * FROM temp_xml

The message I'm getting is

OCI-21500: internal error code, arguments: [58], [], [], [], [], [], [], []
OCI-21500: internal error code, arguments: [kghfrh:ds], [0x23A8724], [], [], [], [], [], []

You don't even need data in the table to produce the error, but it's less likely to disconnect you or have other strange behaviours beyond displaying the error.

Is it possible to fix this in PL/SQL Developer or is this even a PL/SQL Developer bug or limitation? If it is not a PL/SQL Developer bug, any hints on how to reproduce using only SQLPlus so I could open a TAR with Oracle?

 

[Marco Kalter]

Maybe this is an environment problem. Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[djkucera]

Marco,

I am still very interested in resolving this issue, I've just had many things to attend to. Please find the info you requested below:

--- Info ---

PL/SQL Developer
Version 6.0.6.946 (MBCS)
102.23063 - 15 user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 523,276 kB (126,332 available)
Paging file : 1,541,884 kB (1,089,840 available)
Virtual memory : 2,097,024 kB (1,995,612 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
DATASRV1
DATASRV2
PERFORM1
PERFORM2
PERFORM3
SNOOP

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Release 10.2.0.1.0
Character size: 1 byte(s)

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
VOBHOME2.0 = C:\oracle\product\10.2.0\client_1

SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = C:\oracle\product\10.2.0\client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH = C:\oracle\product\10.2.0\client_1\dbs
OO4O = C:\oracle\product\10.2.0\client_1\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home1
MSHELP_TOOLS = C:\oracle\product\10.2.0\client_1\MSHELP
NLS_DATE_FORMAT = YYYY-MM-DD

SOFTWARE\ORACLE\KEY_OraClient10g_home1\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\KEY_OraClient10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.2.0\client_1\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.2.0\client_1\oo4o

--- Path ---

C:\oracle\product\10.2.0\client_1\bin
C:\WINDOWS\SYSTEM32
C:\WINDOWS
C:\WINDOWS\SYSTEM32\WBEM
C:\DMI\WIN32\BIN
C:\OTPPB
C:\Program Files\Microsoft SQL Server\80\Tools\BINN
C:\Program Files\Hummingbird\Connectivity\7.11\Accessories\
C:\PROGRA~1\IBM\CLIENT~1
C:\PROGRA~1\IBM\CLIENT~1\Shared
C:\PROGRA~1\IBM\CLIENT~1\Emulator
c:\unixutil
C:\Lotus\Notes
C:\Program Files\DataDirect\ODBC32v50\Drivers
C:\Program Files\Microsoft Visual Studio\Common\Tools\WinNT
C:\Program Files\Microsoft Visual Studio\Common\MSDev98\Bin
C:\Program Files\Microsoft Visual Studio\Common\Tools
C:\Program Files\Microsoft Visual Studio\VC98\bin
C:\PROGRA~1\FAME\TimeIQ\lib\Windows

--- TNS names ---

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

SNOOP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 9999))
)
(CONNECT_DATA =
(SERVICE_NAME = PERFORM2.OTPP.COM)
)
)

DATASRV1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DATASRV1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATASRV1.OTPP.COM)
)
)

DATASRV2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DATASRV2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATASRV2.OTPP.COM)
)
)

PERFORM3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PERFORM3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PERFORM3.OTPP.COM)
)
)

PERFORM2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PERFORM2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PERFORM2.OTPP.COM)
)
)

PERFORM1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PERFORM1.OTPP.COM)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PERFORM1.OTPP.COM)
)
)

 

[Marco Kalter]

We'll check this out on a 10.2 client and server.