I get error "ORA-24813: cannot send or receive an unsupported LOB" while inserting BLOB data using parameteriz

devendrachitale · Post by **devendrachitale** » Wed 13 Sep 2006 09:15

Hi,

I am using the Oracle driver(version 3.50.12.0) of OraDirect Corelab .NET 2. I have a C# .NET program that uses this driver and tries to execute an INSERT statement into a table that has one of its columns as BLOB.

The INSERT query is a parameterized query that is executed using the standard sequence of commands like using,
creating OracleCommand
creating and setting OracleParameters
and then using the ExecuteNonQuery method of the command object.

1. All this works fine for queries that do not have BLOBS in them.
2. For a query that has a BLOB field it works fine for data of size 2343 bytes.
3. For a query that has a BLOB field and where the data is of size 14228 bytes the insert fails with the following exception,

[CoreLab.Oracle.OracleException] = {"ORA-24813: cannot send or receive an unsupported LOB"}

at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at CoreLab.Common.DbCommandBase.c(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader()
at CoreLab.Common.DbCommandBase.ExecuteNonQuery()

Any help on this will be appreciated.

Alexey · Post by **Alexey** » Wed 13 Sep 2006 13:14

Send us small test project if possible to reproduce the problem; it is
desirable to use 'scott' schema objects, otherwise include definition of
your own database objects. Do not use third party components.

devendrachitale · Post by **devendrachitale** » Wed 13 Sep 2006 13:22

CREATE TABLE file_system
(
file_id VARCHAR2 (40) NOT NULL ,
filename VARCHAR2 (256) NOT NULL ,
localpath VARCHAR2 (512) ,
file_type int DEFAULT 0 NOT NULL ,
file_data BLOB ,
owner_id VARCHAR2 (40) NULL ,
sub_owner_id VARCHAR2 (40) NULL ,
created_on DATE DEFAULT NULL ,
updated_on DATE DEFAULT NULL ,
checksum VARCHAR2 (32) ,
PRIMARY KEY (file_id)
)

This is my table schema. I get the above mentioned error for the column "file_data" for the conditions mentioned in my original post

Alexey · Post by **Alexey** » Fri 15 Sep 2006 09:42

Please provide me with your project as well.