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:[EMAIL PROTECTED]
