LOB Problem

[agasimani]

I have a table containing CLOB field. When I try to delete the rows, it shows me following erro:
ORA-22275: invalid LOB locator specified

When I try to drop the table it shows following error:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

Can somebody out there help me please? And also I want to know how can I load CLOB data into database using SQL Loader?

[tamilselvan]

The control file for loading BLOB/CLOB is:

load data
infile 'test_lob.dat'
append into table test_lob
fields terminated by ','
(id , name, external_filename FILLER,
name_lob LOBFILE(external_filename) TERMINATED BY EOF
)

Please note that when you create a table set default value EMPTY_CLOB() / EMPTY_BLOB() to the LOB column.

The table creation script is :
CREATE TABLE TEST_LOB ( ID NUMBER , NAME VARCHAR2(30), NAME_LOB BLOB DEFAULT EMPTY_BLOB());

[mber]

When you drop the table, try use "cascade constraints" option.

(Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, Oracle returns an error and does not drop the table.)

Thanks