Inserting data into a table with one value as clob and blob
In SQL, the limit is 4,000 characters.  Using straight SQL like that, without a bind 
variable, you'll be limited to 4,000 characters.
Steps to insert lob values :


1) Create a table and name it TBL_CLOB with 2 fields:



   id_int = integer;
    clob_txt =clob;


2) Create a stored procedure and name it P_CLOB  with the following
code:



    (P_ID_INT in int,P_CLOB_TXT in varchar2)as

    begin
    insert into TBL_CLOB values(P_ID_INT,P_CLOB_TXT);
    end;

 


3) Test inserting up to 32000. Use SQL Plus and enter some starts in 
the CLOB field:



    SQL>  exec p_clob(1,rpad('*',32000,'*'));

    SQL> commit;

    SQL>  exec p_clob(2,rpad('*',19872,'*'));

    SQL> commit;

 


4) Retrieve the 2 records you just inserted and count the number of
characters in the CLOB fields:



    SQL> select id_int,dbms_lob.getlength(clob_txt) from tbl_clob;



5) You should get something like this:



        ID_INT DBMS_LOB.GETLENGTH(CLOB_TXT)
    ---------- ----------------------------
             1                        32000
             2                        19872


Makes sense ?