Returning an xmltype appears to cause problems

[csquared]

When issuing the following query from within a SQL window, the "Initializing..." message appears for a long time, followed by an alert window.

The query is:
select xmltype('b value') from dual;

The message box error is:
ORA-12154: TNS could not resolve service name.

I was previously connected and working with the database and did not receive the TNS error. I'm running against and Oracle 11.1 database and am working on XML DB tasks.

 

[Marco Kalter]

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

 

[csquared]

--- Info ---

PL/SQL Developer
Version 7.1.3.1381
01.43999 - Unlimited user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 2,095,172 kB (787,492 available)
Paging file : 4,031,976 kB (1,947,816 available)
Virtual memory : 2,097,024 kB (1,992,124 available)

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

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

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\colclcm1\default.ini

Plug-Ins

Aliases
EXTPROC_CONNECTION_DATA.JHUAPL.EDU
GUVI.JHUAPL.EDU
INST1_HTTP.JHUAPL.EDU
MIZAR
TMDC

Homes
agent10g (C:\OracleHomes\agent10g)
db10g (C:\OracleHomes\db10g)
oms10g (C:\OracleHomes\oms10g)
Ora9i (C:\ora9i)
OUIHome1 (C:\OraHome_1)

DLLs
C:\ora9i\bin\oci.dll

TNS File
C:\ora9i\Network\Admin\tnsnames.ora

Using
Home: Ora9i
DLL: C:\ora9i\bin\oci.dll
OCI: version 9.2
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0

Character Sets
Character size: 1 byte(s)
CharSetID: 46
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: WE8ISO8859P15
NLS_NCHAR_CHARACTERSET: AL16UTF16

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME_NAME = Ora9i
API = C:\ora9i\dbs
ORACLE_GROUP_NAME = Oracle - Ora9i
NLS_LANG = NA
ORA_CRS_HOME = C:\OracleHomes\db10g
ORACLE_HOME = C:\ora9i
VOBHOME2.0 = C:\OraHome_1

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = Ora9i
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = Ora9i
PATH = C:\ora9i
NLS_LANG = NA

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - Ora9i
ORACLE_HOME_NAME = Ora9i
ORACLE_HOME = C:\ora9i
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

SOFTWARE\ORACLE\iSuites
MDAC Session Update Status = Complete

SOFTWARE\ORACLE\KEY_agent10g
ORACLE_HOME = C:\OracleHomes\agent10g
ORACLE_HOME_NAME = agent10g
ORACLE_GROUP_NAME = Oracle - agent10g
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

SOFTWARE\ORACLE\KEY_db10g
ORACLE_HOME = C:\OracleHomes\db10g
ORACLE_HOME_NAME = db10g
ORACLE_GROUP_NAME = Oracle - db10g
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_SID = emrep
SQLPATH = C:\OracleHomes\db10g\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_db10g
MSHELP_TOOLS = C:\OracleHomes\db10g\MSHELP
RDBMS_CONTROL = C:\OracleHomes\db10g\DATABASE
RDBMS_ARCHIVE = C:\OracleHomes\db10g\DATABASE\ARCHIVE
ORA_EMREP_AUTOSTART = TRUE
ORA_EMREP_SHUTDOWN = TRUE
ORA_EMREP_SHUTDOWNTYPE = immediate
ORA_EMREP_SHUTDOWN_TIMEOUT = 90

SOFTWARE\ORACLE\KEY_oms10g
ORACLE_HOME = C:\OracleHomes\oms10g
ORACLE_HOME_NAME = oms10g
ORACLE_GROUP_NAME = Oracle - oms10g
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_OPMN_SERVICE = Oracleoms10gProcessManager
SQLPATH = C:\OracleHomes\oms10g\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_oms10g

SOFTWARE\ORACLE\KEY_oms10g\HTTP_Server
Path = C:\OracleHomes\oms10g\bin;C:\OracleHomes\oms10g\Perl\5.6.1\bin\MSWin32-x86;C:\OracleHomes\oms10g\Apache\Apache\fastcgi;C:\OracleHomes\oms10g\opmn\bin;C:\OracleHomes\oms10g\opmn\lib

SOFTWARE\ORACLE\KEY_OUIHome1
ORACLE_HOME = C:\OraHome_1
ORACLE_HOME_NAME = OUIHome1
ORACLE_GROUP_NAME = Oracle - OUIHome1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH = C:\OraHome_1\dbs
MSHELP_TOOLS = C:\OraHome_1\MSHELP
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OUIHome1

SOFTWARE\ORACLE\Ocr
ocrconfig_loc = C:\OracleHomes\db10g\cdata\localhost\local.ocr
Local_Only = TRUE

SOFTWARE\ORACLE\SCR

SOFTWARE\ORACLE\SYSMAN

SOFTWARE\ORACLE\SYSMAN\Oracleagent10gAgent
EMDROOT = C:\OracleHomes\agent10g
ORACLE_HOME = C:\OracleHomes\agent10g
TIMEOUT = 15
TRACE_LEVEL = 16
CONSOLE_CFG = agent

SOFTWARE\ORACLE\SYSMAN\Oracleoms10gASControl
EMDROOT = C:\OracleHomes\oms10g
ORACLE_HOME = C:\OracleHomes\oms10g
TIMEOUT = 15
TRACE_LEVEL = 16
CONSOLE_CFG = iasconsole

SOFTWARE\ORACLE\SYSMAN\Oracleoms10gCentralConole

SOFTWARE\ORACLE\SYSMAN\Oracleoms10gCentralConsole
EMDROOT = C:\OracleHomes\oms10g
JAVA_HOME = C:\OracleHomes\oms10g/jdk
ORACLE_HOME = C:\OracleHomes\oms10g
JRE_HOME = C:\OracleHomes\oms10g/jdk
ADDL_PATH = C:\OracleHomes\oms10g\bin;C:\OracleHomes\oms10g\jdk\jre\bin\client;C:\OracleHomes\oms10g\perl\5.6.1\bin\MSWin32-x86
ORA_NLS = C:\OracleHomes\oms10g\ocommon\nls\admin\data
ORA_NLS32 = C:\OracleHomes\oms10g\ocommon\nls\admin\data
ORA_NLS33 = C:\OracleHomes\oms10g\ocommon\nls\admin\data
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
PERL5LIB = C:\OracleHomes\oms10g\perl\5.6.1\bin\MSWin32-x86;C:\OracleHomes\oms10g\perl\5.6.1\lib;C:\OracleHomes\oms10g\perl\5.6.1\lib\MSWin32-x86;C:\OracleHomes\oms10g\perl\site\5.6.1\lib;C:\OracleHomes\oms10g\perl\site\5.6.1\lib\Win32;C:\OracleHomes\oms10g\sysman\admin\scripts

SOFTWARE\ORACLE\Workflow
Icon Directory = C:\ora9i\WF\ICON
Level = d

 

[Marco Kalter]

Thanks. 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.