Struggling with insertion of Clob into the database.

[Prashanth Sukumaran <pr...@yahoo.com>]

Hi,

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

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

Thanks
Prashanth.


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

Re: Struggling with insertion of Clob into the database. PS:

[Andrey Rogov <ko...@i-c.com.ua>]

Before updating CLOB object you must create it.
First of all I've got new primary key ( by sequence ), Insert ' ' into clob simply
insert ' ' into ... clob, and when object was created, write string.

I use Oracle 9i,
classes12.jar.


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/ 



-- 
regards,
 Andrey                          mailto:konus@i-c.com.ua

Re: Struggling with insertion of Clob into the database.

[Andrey Rogov <ko...@i-c.com.ua>]

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@i-c.com.ua