Hi All,

I am trying to insert large file as CLOB object into CLOB field of Oracle 10g. I am using Unix ksh where the file is prepared and sends the file to stored procedure which tries to insert the file into DB.

When i am trying it throws an exception ORA-00972: identifier is too long. As i read in some sites that CLOB can store upto 4GB of file.

Please help with some sample shell script how can i store file as CLOB object to CLOB field in Oracle10g database.

Its very urgent.

Thanks,
Rajesh

Maybe you could find an answer if you read about DBMS_LOB package in the fine Oracle® Database PL/SQL Packages and Types Reference.