problem with statement

[Uli Kobsa]

Hi,

I have a problem running the following statement (on SCOTT):

select xmlelement("empno", empno) from emp;

it works fine on SQLPlus but it hangs in command window or in SQL window and I have to kill plsql Developer.

Any ideas what I do wrong?

greetings,
Uli

support info:

PL/SQL Developer
Version 6.0.5.931 (MBCS)
01.25047 - 1 user license
Windows XP version 6,0 (build 2600) Service Pack 2

Physical memory : 523.184 kB (127.980 available)
Paging file : 1.279.464 kB (884.512 available)
Virtual memory : 2.097.024 kB (1.972.220 available)

Parameters
C:\Programme\Allround Automations\plsql developer\plsqldev.exe

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

Plug-Ins
*Browser Extender Version 2.5.1 (Build 53) by Joachim Rupik (C:\Programme\Allround Automations\plsql developer\PlugIns\be.dll)
*Comment lines v1.1 (C:\Programme\Allround Automations\plsql developer\PlugIns\commentline.dll)
*PL/SQL Developer CompareSource Plug-In version 2003/12/03 (C:\Programme\Allround Automations\plsql developer\PlugIns\CompareSource.dll)
*Easy Bookmark 1.0.1 (C:\Programme\Allround Automations\plsql developer\PlugIns\Easy_BM.dll)
*PL/SQL Developer FindAll Plug-In version 2003/11/18 (C:\Programme\Allround Automations\plsql developer\PlugIns\FindAll.dll)
*PasteOptions 1.2 (C:\Programme\Allround Automations\plsql developer\PlugIns\PasteOptions.dll)
*PL/SQL Documentation (plsqldoc) (C:\Programme\Allround Automations\plsql developer\PlugIns\plsqldoc.dll)
*Quick/ER - Gotterup.Net (C:\Programme\Allround Automations\plsql developer\PlugIns\QuickERPlugin.dll)
*Save separate v1.0 (C:\Programme\Allround Automations\plsql developer\PlugIns\saveseparate.dll)
*PL/SQL Developer Scale Plug-In (C:\Programme\Allround Automations\plsql developer\PlugIns\Scale.dll)
*User-defined Export 1.0 (C:\Programme\Allround Automations\plsql developer\PlugIns\TextExport.dll)
*Version Control Interface 1.2 (C:\Programme\Allround Automations\plsql developer\PlugIns\VCS.dll)
*Wrap demo version 1.0 (C:\Programme\Allround Automations\plsql developer\PlugIns\wrap.dll)
(* is Active)

Aliases
EXTPROC_CONNECTION_DATA
INST1_HTTP
NB1
PC1
PC2

Homes
ORA92 (D:\Oracle\Ora92)

DLLs
D:\Oracle\Ora92\bin\oci.dll

TNS File
D:\Oracle\Ora92\Network\Admin\tnsnames.ora

Using
Home: ORA92
DLL: D:\Oracle\Ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Release 9.2.0.1.0
Character size: 1 byte(s)

 

[Marco Kalter]

This is an Oracle 9.2 bug (works fine on 10g). Use the following statement instead:

select xmlelement("empno", empno).getclobval() from emp;

 

[Uli Kobsa]

Thanks Marco,

this way it works fine.

greetings,
Uli