ora-24813: cannot send or receive an unsopported LOB

[lizhongliang]

I run the sql "select dbms_xmlgen.getXML('SELECT * FROM all_OBJECTS WHERE ROWNUM < 10',1) from dual" on my plsql developer. It returns error "ora-24813: cannot send or receive an unsopported LOB". Could you tell me why? By the way my version is 7.1.2.1363 Unlimited user license Windows XP Professional 5.1 Build 2600 (Service Pack 3)

 

[Marco Kalter]

This works fine for me. Maybe this is an environment problem. 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?

 

[lizhongliang]

Support Info is as follows

--- Info ---

PL/SQL Developer
Version 7.1.2.1363
- Unlimited user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2,062,564 kB (1,294,424 available)
Paging file : 3,967,592 kB (3,298,828 available)
Virtual memory : 2,097,024 kB (1,956,148 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\lizhl\default.ini

Plug-Ins

Aliases
Maximo_PROD
MY_ORACLE
SAP_C01
SAP_PRD
TMS_PRD

Homes
DEFAULT_HOME (C:\orant)

DLLs
C:\orant\bin\oci.dll
C:\orant\bin\ORA803.DLL
C:\orant\bin\ORA804.DLL
C:\orant\bin\ORA805.DLL

TNS File
C:\orant\Net80\Admin\tnsnames.ora

Using
Home: DEFAULT_HOME
DLL: C:\orant\bin\oci.dll
OCI: Version 8.0
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

Character Sets
Character size: 2 byte(s)
CharSetID: 852
NCharSetID: 2000
Unicode Support: True
NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
NLS_CHARACTERSET: ZHS16GBK
NLS_NCHAR_CHARACTERSET: AL16UTF16

--- Registry ---

SOFTWARE\ORACLE
ORACLE_HOME = C:\orant
ORACLE_HOME_NAME = DEFAULT_HOME
SHARED_ORACLE_HOME = C:\orant
API = C:\orant\DBS
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
COMPANY_NAME = cnooc
ORACLE_GROUP_NAME = Oracle for Windows NT
RDBMS80 = C:\orant\RDBMS80
PLSQL80 = C:\orant\PLSQL80
CORE40 = C:\orant\CORE40
NLSRTL33 = C:\orant\NLSRTL33
ORA_NLS33 = C:\orant\NLSRTL33\DATA
PRO80 = C:\orant\PRO80
OTRACE80 = C:\orant\OTRACE80
NET80 = C:\orant\NET80
inst_loc = C:\Program Files\Oracle\Inventory

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

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = DEFAULT_HOME
PATH = C:\orant
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

SOFTWARE\ORACLE\Desktop Sharing Run-Time

SOFTWARE\ORACLE\Desktop Sharing Run-Time\Driver Usage
{6EC12D06-9C55-4609-9105-C33093D5717C} =

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_HOME = C:\orant
ORACLE_HOME_NAME = DEFAULT_HOME
SHARED_ORACLE_HOME = C:\orant
API = C:\orant\DBS
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
COMPANY_NAME = cnooc
ORACLE_GROUP_NAME = Oracle for Windows NT
D2K60_COMPONENTS = Oracle Forms & Reports 6i Comps
D2K60_ADMINISTRATION = Oracle Forms & Reports 6i Admin
D2KOR60_ADMINISTRATION = Oracle Reports 6i Admin
D2KIF60_ADMINISTRATION = Oracle Forms 6i Admin
D2K60_DEMOS = Oracle Forms & Reports 6i Demos
D2K60_DOCS = Oracle Forms & Reports 6i Doc
D2K60_GROUP = Oracle Forms & Reports 6i
D2KOR60_GROUP = Oracle Reports 6i
D2KIF60_GROUP = Oracle Forms 6i
D2K60_DRIVERS = Oracle Forms & Reports 6i Direct Drivers
OPEN2K60_DOCS = Oracle Forms & Reports 6i Doc

SOFTWARE\ORACLE\JInitiator
Java Runtime = Default
JIT Enabled = 1
JIT path = symcjit
Java Runtime Parameters = -mx64m -Dcache.size=50000000
Show Console = 0

SOFTWARE\ORACLE\JInitiator\1.1

SOFTWARE\ORACLE\JInitiator\1.1.8

SOFTWARE\ORACLE\JInitiator\1.1.8.19
Home = C:\PROGRA~1\Oracle\JINITI~1.19

SOFTWARE\ORACLE\JInitiator\Default
Home = C:\PROGRA~1\Oracle\JINITI~1.19

SOFTWARE\ORACLE\ORACLE_HOMES

SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE0
ORACLE_HOME = C:\orant
ORACLE_HOME_NAME = DEFAULT_HOME
SHARED_ORACLE_HOME = C:\orant
API = C:\orant\DBS
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
COMPANY_NAME = cnooc
ORACLE_GROUP_NAME = Oracle for Windows NT

SOFTWARE\ORACLE\SCR

SOFTWARE\ORACLE\SYSMAN

--- Path ---

C:\orant\bin
C:\Program Files\Common Files\NetSarang
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\Intel\Wireless\Bin\
C:\Program Files\Diskeeper Corporation\Diskeeper\
C:\Program Files\ThinkPad\ConnectUtilities
C:\Program Files\Common Files\Lenovo
C:\Program Files\Lenovo\Client Security Solution
C:\Program Files\Windows Imaging\
C:\Program Files\Common Files\Thunder Network\KanKan\Codecs

--- TNS names ---

Maximo_PROD=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.63.0.34)(PORT = 1521))
(CONNECT_DATA = (SID = maximo))
)

SAP_C01=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.57.1.144)(PORT = 1527))
(CONNECT_DATA = (SID =C01))
)

SAP_PRD=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.68.106.236)(PORT = 1527))
(CONNECT_DATA = (SID =P09))
)

TMS_PRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.57.1.143)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

MY_ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lizhlm.beijing.cnooc.corp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

 

[Marco Kalter]

I see you are using Oracle Net 8.0.5, which does not support the temporary CLOB returned by dbms_xmlgen.getXML. You will need to upgrade to a 9.0 client or later.