CLOB

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Thu, 30 Jun 2005 11:39 am

How do I do an insert or an update on a table with CLOB field?

I tried doing the following insert (the XML field is of type CLOB):
Code: Select all
INSERT INTO TIPO_JRELATORIO
(COD_TIPOJRELATORIO,NOME,XML,COD_AGRUPADOR,ORDEM)
VALUES
(1,'Tarefas por Cliente','<?xml version="1.0" encoding="ISO-8859-1"  ?>
<jasperReport
       name="classic"
       columnCount="1"
       printOrder="Vertical"
       orientation="Portrait"
       pageWidth="595"
       pageHeight="842"
       columnWidth="535"
       columnSpacing="0"
       leftMargin="30"
       rightMargin="30"
       topMargin="20"
       bottomMargin="20"
       whenNoDataType="AllSectionsNoDetail"
       isTitleNewPage="false"
       isSummaryNewPage="false">
   <parameter name="DATA4_INI" isForPrompting="false" class="java.util.Date">
...
</jasperReport>',1,1)
and took the error ORA-01704 \"string literal too long\"
rogers
Location: RJ

Poston Thu, 30 Jun 2005 12:02 pm

I found this link on the forum ... see if that helps!
viewtopic.php?t=247&highlight=clob Has an example of how to insert a clob ASKTOM ... If it worked, let the guys!
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Thu, 30 Jun 2005 3:51 pm

It Worked!
Thank you very much!!!
rogers
Location: RJ


  • See also
    Replies
    Views
    Last Post


Return to SQL

Who is online

Users browsing this forum: No registered users and 1 guest



cron