Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Tuesday, January 27, 2009

ORA-24813: cannot send or receive an unsupported LOB

I used dbms_metadata package to get the definition of a view while logged in from 806 ORACLE_HOME

  1  select dbms_metadata.get_ddl('VIEW','MRP_AP_PROCESS_EFFECTIVITY_V','APPS')
  2* FROM DUAL
SQL> /
FROM DUAL
     *
ERROR at line 2:
ORA-24813: cannot send or receive an unsupported LOB

Error: ORA-24813 Text: cannot send or receive an unsupported LOB  --------------------------------------------------------------------------- Cause: An attempt was made to send a LOB across the network, but either the   server does not support the LOB sent by the client, or the client does   not support the LOB sent by the server. This error usually occurs when   the client and server are running different versions of Oracle.  Action: Use a version of the Oracle that supports the LOB on both the client   and the server.

ORA-24813: cannot send or receive an unsupported LOB
Cause: An attempt was made to send a LOB across the network, but either the server does not support the LOB sent by the client, or the client does not support the LOB sent by the server. This error usually occurs when the client and server are running different versions of Oracle.
Action: Use a version of the Oracle that supports the LOB on both the client and the server.

Connect with 10g client and the command works.

SQL> select dbms_metadata.get_ddl('VIEW','MRP_AP_PROCESS_EFFECTIVITY_V','APPS')
FROM DUAL  2
  3  /

DBMS_METADATA.GET_DDL('VIEW','MRP_AP_PROCESS_EFFECTIVITY_V','APPS')
--------------------------------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "APPS"."MRP_AP_PROCESS_EFFECTIVITY_V" ("INVENT
OR


SQL> set long2000
SQL> /

DBMS_METADATA.GET_DDL('VIEW','MRP_AP_PROCESS_EFFECTIVITY_V','APPS')
--------------------------------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "APPS"."MRP_AP_PROCESS_EFFECTIVITY_V" ("INVENT
ORY_ITEM_ID", "ORGANIZATION_ID", "BILL_SEQUENCE_ID",
 "ALTERNATE_BOM_DESIGNATOR", "ALTERNATE_ROUTING_DESI
GNATOR", "ROUTING_SEQUENCE_ID", "LINE_ID", "PREFEREN
CE", "PRIMARY_LINE_FLAG", "PRODUCTION_LINE_RATE", "L
OAD_DISTRIBUTION_PRIORITY", "EFFECTIVITY_DATE", "ATT
RIBUTE1", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4",
"ATTRIBUTE5", "ATTRIBUTE6", "ATTRIBUTE7", "ATTRIBUTE
8", "ATTRIBUTE9", "ATTRIBUTE10", "ATTRIBUTE11", "ATT
RIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14", "ATTRIBUTE15", "RN4", "RN3", "RN2", "RN1") AS
  select items.inventory_item_id,
       items.organization_id,
       b.bill_sequence_id * 2 bill_sequence_id,
       b.alternate_bom_designator,
       r.alternate_routing_designator,
       r.routing_sequence_id * 2 routing_sequence_id,
       TO_NUMBER(NULL) LINE_ID,
       nvl(r.priority, DECODE( b.alternate_bom_designator,
               NULL, DECODE( r.alternate_routing_designator,
                             NULL, 1,
                             2),
               2)) PREFERENCE,
       TO_NUMBER(NULL) PRIMARY_LINE_FLAG,
       TO_NUMBER(NULL) PRODUCTION_LINE_RATE,
       TO_NUMBER(NULL) LOAD_DISTRIBUTION_PRIORITY,
       SYSDATE EFFECTIVITY_DATE,
       b.attribute1,
       b.attribute2,
       b.attribute3,
       b.attribute4,
       b.attribute5,
       b.attribute6,
       b.attribute7,
       b.attribute8,
       b.attribute9,
       b.attribute10,
       b.attribute11,
       b.attribute12,
       b.attribute13,
       b.attribute14,
       b.attribute15,
       NVL(r.RN,0)     RN4,
       NVL(b.RN,0)     RN3,
       items.RN        RN2,
       0           RN1
from MRP_SN_BOMS b,
     MRP_SN_OPR_RTNS r,
     MRP_SN_SYS_ITEMS items
where items.inventory_item_id = b.assembly_item_id(+)
and items.organization_id = b.organization_id(+)
and items.inventory_item_id = r.assembly_item_id (+)
and items.organization_id = r.organization_id (+)
and ( (r.routing_sequence_id IS NULL and b.bill

No comments: