Re: Struggling with insertion of Clob into the database.

I insert String into Oracle CLOB throw stored procedure.
IBatis very ease call stored Procedures, therefore
I decided to use it.

iBatis:

<procedure id="writeclob" parameterMap="clobparam" >
   { call db.writeclob( ?, ?, ?, ? ,? ) }
</procedure>
<parameterMap id="clobparam" class="Map"
   1. YourString,
   2. string.length()
   3. offset - 0
   4. id record
   5. language
</parameterMap>

Oracle sp:

create or replace procedure WRITECLOB( sText varchar2 ,
                                       namount number ,
                                       noffset number ,
                                       nmes number ,
                                       nlanguage number ) is

mcl clob ;

begin
  
     select m.messageua
       into mcl
       from sell.messages m
      where m.message = nmes for update ;
   
     sys.dbms_lob.trim(mcl, 1 );
    
     sys.dbms_lob.write( mcl ,
                         namount ,
                         noffset ,
                         sText );

                              
end WRITECLOB ; 

Andrey.

PS> Hi,

PS> I am trying to insert a String into a CLOB field into an Oracle Database.

PS> Can anybody paste the code for this if you have already done this.

PS> Thanks
PS> Prashanth.


                
PS> __________________________________ 
PS> Do you Yahoo!? 
PS> Yahoo! Small Business - Try our new resources site!
PS> http://smallbusiness.yahoo.com/resources/ 



-- 
С уважением,
 Andrey                          mailto:konus@xxxxxxxxxx