Home » SQL & PL/SQL » SQL & PL/SQL » Unable to insert into CLOB column
Unable to insert into CLOB column [message #185945] Fri, 04 August 2006 07:45 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
hi all
when i try to execute the following command, i am getting the error like ora-01704:string literal too long.
where as REPORT_TEMPLATE column was defined as CLOB.

Pls help on this.

Thanks

insert into report_info_detail (REPORT_INFO_ID, REPORT_EXPORT_TYPE_CODE, PLUGIN_CLASS_NAME, IS_ACTIVE,REPORT_TEMPLATE) 
select r.report_info_id, --REPORT_INFO_ID 
        'pdf', --REPORT_EXPORT_TYPE_CODE (htm, pdf,csv) 
        'com.ocs.poetic.reports.JRActivatedLicAssetReportPlugin',--PLUGIN_CLASS_NAME 
        -1, --IS_ACTIVE 
        --REPORT_TEMPLATE 
'<?xml version="1.0" encoding="UTF-8"  ?> 
<!-- Created with iReport - A designer for JasperReports --> 
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport 
                 name="ActivatedLicAssetReportTemplate" 
                 language="java" 
                 columnCount="1" 
                 printOrder="Vertical" 
                 orientation="Portrait" 
                 pageWidth="842" 
                 pageHeight="595" 
                 columnWidth="782" 
                 columnSpacing="0" 
                 leftMargin="30" 
                 rightMargin="30" 
                 topMargin="20" 
                 bottomMargin="20" 
                 whenNoDataType="AllSectionsNoDetail" 
                 isTitleNewPage="false" 
                 isSummaryNewPage="false" 
                 resourceBundle="JasperReportsLocalization" 
                 whenResourceMissingType="Empty"> 
        <property name="ireport.scriptlethandling" value="0" /> 
        <property name="ireport.encoding" value="UTF-8" /> 
        <import value="java.util.*" /> 
        <import value="net.sf.jasperreports.engine.*" /> 
        <import value="net.sf.jasperreports.engine.data.*" /> 

        <parameter name="DataFile" isForPrompting="true" class="java.lang.String"/> 
        <parameter name="CompanyName" isForPrompting="true" class="java.lang.String"/> 
        <parameter name="CertStatus" isForPrompting="true" class="java.lang.String"/> 

        <field name="COMPANY_NAME" class="java.lang.String"/> 
        <field name="CITY" class="java.lang.String"/> 
        <field name="TARGET_ID" class="java.lang.String"/> 
        <field name="LKP(PRODUCT_LINE)PRODUCT_LINE" class="java.lang.String"/> 
        <field name="LKP(FAMILY)PRODUCT_FAMILY_CODE" class="java.lang.String"/> 
        <field name="LKP(COUNTRY)COUNTRY_CODE" class="java.lang.String"/> 
        <field name="EMAIL" class="java.lang.String"/> 
        <field name="LTU" class="java.math.BigDecimal"/> 

        <variable name="ltuGroupSum" class="java.math.BigDecimal" resetType="Group" incrementType="Group" incrementGroup="COMPANY_NAME" resetGroup="COMPANY_NAME" calculation="Sum">

                <variableExpression><![CDATA[$F{LTU}]]></variableExpression> 
        </variable> 
        <variable name="LtuSum" class="java.math.BigDecimal" resetType="Group" resetGroup="GROUP_LTU" calculation="Sum">

                <variableExpression><![CDATA[$F{LTU}]]></variableExpression> 
        </variable> 

                <group  name="COMPANY_NAME" > 
                        <groupExpression><![CDATA[$F{COMPANY_NAME}]]></groupExpression> 
                        <groupHeader> 
                        <band height="20"  isSplitAllowed="true" > 
                                <rectangle> 
                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="780" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#0066CC" 
                                                key="rectangle"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </rectangle> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-1_COMPANY_NAME"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{COMPANY_NAME}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="105" 
                                                y="0" 
                                                width="144" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-1_COMPANY_NAME"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{COMPANY_NAME}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="250" 
                                                y="0" 
                                                width="42" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-2_EMAIL"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{EMAIL}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="296" 
                                                y="0" 
                                                width="49" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-2_EMAIL"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{EMAIL}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="350" 
                                                y="0" 
                                                width="29" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-3_CITY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{CITY}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="381" 
                                                y="0" 
                                                width="149" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-3_CITY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{CITY}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="538" 
                                                y="0" 
                                                width="65" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-4_COUNTRY_CODE"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{LKP(COUNTRY)COUNTRY_CODE}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="608" 
                                                y="0" 
                                                width="50" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-5_LTU"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="COMPANY_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="665" 
                                                y="0" 
                                                width="50" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#FFCCCC" 
                                                key="textField-5_ltuGroupSum"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{ltuGroupSum}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="COMPANY_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="719" 
                                                y="0" 
                                                width="50" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#FFCCCC" 
                                                key="textField-5_LtuSum"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{LtuSum}]]></textFieldExpression>

                                </textField> 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="2"  isSplitAllowed="true" > 
                                <line direction="BottomUp"> 
                                        <reportElement 
                                                x="0" 
                                                y="-6" 
                                                width="1" 
                                                height="1" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </line> 
                        </band> 
                        </groupFooter> 
                </group> 
                <group  name="TARGET_ID" > 
                        <groupExpression><![CDATA[$F{TARGET_ID}]]></groupExpression> 
                        <groupHeader> 
                        <band height="20"  isSplitAllowed="true" > 
                                <rectangle> 
                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="745" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#0099CC" 
                                                key="rectangle-1" 
                                                positionType="FixRelativeToBottom"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </rectangle> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{TARGET_ID}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="140" 
                                                y="0" 
                                                width="300" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{TARGET_ID}]]></textFieldExpression>

                                </textField> 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="2"  isSplitAllowed="true" > 
                                <line direction="BottomUp"> 
                                        <reportElement 
                                                x="0" 
                                                y="-5" 
                                                width="1" 
                                                height="1" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </line> 
                        </band> 
                        </groupFooter> 
                </group> 
                <group  name="PRODUCT_LINE" > 
                        <groupExpression><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></groupExpression> 
                        <groupHeader> 
                        <band height="20"  isSplitAllowed="true" > 
                                <rectangle> 
                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="745" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#009999" 
                                                key="rectangle-2" 
                                                positionType="FixRelativeToBottom"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </rectangle> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{PRODUCT_LINE}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="140" 
                                                y="0" 
                                                width="300" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></textFieldExpression>

                                </textField> 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="10"  isSplitAllowed="true" > 
                        </band> 
                        </groupFooter> 
                </group> 
                <group  name="GROUP_LTU" > 
                        <groupExpression><![CDATA[$F{LTU}]]></groupExpression> 
                        <groupHeader> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                        </groupFooter> 
                </group> 
                <background> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </background> 
                <title> 
                        <band height="30"  isSplitAllowed="true" > 
                                <line direction="TopDown"> 
                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="782" 
                                                height="1" 
                                                forecolor="#808080" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="2Point"/> 
                                </line> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="0" 
                                                y="5" 
                                                width="782" 
                                                height="20" 
                                                key="staticText"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement textAlignment="Center"> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{activation_report_title}]]></textFieldExpression>

                                </textField> 
                                <line direction="TopDown"> 
                                        <reportElement 
                                                x="0" 
                                                y="25" 
                                                width="782" 
                                                height="1" 
                                                forecolor="#808080" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="2Point"/> 
                                </line> 
                        </band> 
                </title> 
                <pageHeader> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </pageHeader> 
                <columnHeader> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </columnHeader> 
                <detail> 
                        <band height="45"  isSplitAllowed="true" > 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="50" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                key="staticText-1_FAMILY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{FAMILY}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="150" 
                                                y="0" 
                                                width="335" 
                                                height="20" 
                                                key="textField-1_FAMILY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{LKP(FAMILY)PRODUCT_FAMILY_CODE}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="50" 
                                                y="20" 
                                                width="100" 
                                                height="20" 
                                                key="staticText-2_LTU"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="150" 
                                                y="20" 
                                                width="335" 
                                                height="20" 
                                                key="textField-2_LTU"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{LTU}]]></textFieldExpression>

                                </textField> 
                        </band> 
                </detail> 
                <columnFooter> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </columnFooter> 
                <pageFooter> 
                        <band height="40"  isSplitAllowed="true" > 
                                <line direction="TopDown"> 
                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="782" 
                                                height="1" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="2Point"/> 
                                </line> 
                                <image  scaleImage="FillFrame" isUsingCache="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                mode="Opaque" 
                                                x="0" 
                                                y="5" 
                                                width="140" 
                                                height="35" 
                                                key="image-1"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <graphicElement stretchType="NoStretch"/> 
                                        <imageExpression class="java.lang.String"><![CDATA[$R{image_ocs_logo}]]></imageExpression>

                                </image> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="145" 
                                                y="0" 
                                                width="200" 
                                                height="15" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement textAlignment="Right"> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="351" 
                                                y="0" 
                                                width="127" 
                                                height="15" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="607" 
                                                y="0" 
                                                width="69" 
                                                height="15" 
                                                key="textField-5"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{execution_date}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="679" 
                                                y="0" 
                                                width="101" 
                                                height="15" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="145" 
                                                y="15" 
                                                width="350" 
                                                height="10" 
                                                key="textField-3"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement textAlignment="Center"> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{disclaimer_line_1}]]></textFieldExpression>

                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >

                                        <reportElement 
                                                x="145" 
                                                y="30" 
                                                width="350" 
                                                height="10" 
                                                key="textField-4"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

                                        <textElement textAlignment="Center"> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{disclaimer_line_2}]]></textFieldExpression>

                                </textField> 
                        </band> 
                </pageFooter> 
                <summary> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </summary> 
</jasperReport>' 
from report_info r where security_resource_name = 'ACTIVATED_LIC_ASSET_REPORT' 
Re: Unable to insert into CLOB column [message #185957 is a reply to message #185945] Fri, 04 August 2006 09:02 Go to previous messageGo to next message
Aju
Messages: 94
Registered: October 2004
Member
Here is a turn around method


CREATE TABLE TEST (x CLOB);

DECLARE
y CLOB ;
BEGIN
y := '<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport
name="ActivatedLicAssetReportTemplate"
language="java"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="842"
pageHeight="595"
columnWidth="782"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="AllSectionsNoDetail"
isTitleNewPage="false"
isSummaryNewPage="false"
resourceBundle="JasperReportsLocalization"
whenResourceMissingType="Empty">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />

<parameter name="DataFile" isForPrompting="true" class="java.lang.String"/>
<parameter name="CompanyName" isForPrompting="true" class="java.lang.String"/>
<parameter name="CertStatus" isForPrompting="true" class="java.lang.String"/>

<field name="COMPANY_NAME" class="java.lang.String"/>
<field name="CITY" class="java.lang.String"/>
<field name="TARGET_ID" class="java.lang.String"/>
<field name="LKP(PRODUCT_LINE)PRODUCT_LINE" class="java.lang.String"/>
<field name="LKP(FAMILY)PRODUCT_FAMILY_CODE" class="java.lang.String"/>
<field name="LKP(COUNTRY)COUNTRY_CODE" class="java.lang.String"/>
<field name="EMAIL" class="java.lang.String"/>
<field name="LTU" class="java.math.BigDecimal"/>

<variable name="ltuGroupSum" class="java.math.BigDecimal" resetType="Group" incrementType="Group" incrementGroup="COMPANY_NAME" resetGroup="COMPANY_NAME" calculation="Sum">

<variableExpression><![CDATA[$F{LTU}]]></variableExpression>
</variable>
<variable name="LtuSum" class="java.math.BigDecimal" resetType="Group" resetGroup="GROUP_LTU" calculation="Sum">

<variableExpression><![CDATA[$F{LTU}]]></variableExpression>
</variable>

<group name="COMPANY_NAME" >
<groupExpression><![CDATA[$F{COMPANY_NAME}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle>
<reportElement
x="0"
y="0"
width="780"
height="20"
forecolor="#000000"
backcolor="#0066CC"
key="rectangle"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="0"
y="0"
width="100"
height="20"
forecolor="#000000"
key="staticText-1_COMPANY_NAME"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{COMPANY_NAME}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="105"
y="0"
width="144"
height="20"
forecolor="#000000"
key="textField-1_COMPANY_NAME"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{COMPANY_NAME}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="250"
y="0"
width="42"
height="20"
forecolor="#000000"
key="staticText-2_EMAIL"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{EMAIL}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="296"
y="0"
width="49"
height="20"
forecolor="#000000"
key="textField-2_EMAIL"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{EMAIL}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="350"
y="0"
width="29"
height="20"
forecolor="#000000"
key="staticText-3_CITY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{CITY}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="381"
y="0"
width="149"
height="20"
forecolor="#000000"
key="textField-3_CITY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CITY}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="538"
y="0"
width="65"
height="20"
forecolor="#000000"
key="textField-4_COUNTRY_CODE"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{LKP(COUNTRY)COUNTRY_CODE}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="608"
y="0"
width="50"
height="20"
forecolor="#000000"
key="staticText-5_LTU"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="COMPANY_NAME" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="665"
y="0"
width="50"
height="20"
forecolor="#000000"
backcolor="#FFCCCC"
key="textField-5_ltuGroupSum"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ltuGroupSum}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="COMPANY_NAME" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="719"
y="0"
width="50"
height="20"
forecolor="#000000"
backcolor="#FFCCCC"
key="textField-5_LtuSum"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{LtuSum}]]></textFieldExpression>

</textField>
</band>
</groupHeader>
<groupFooter>
<band height="2" isSplitAllowed="true" >
<line direction="BottomUp">
<reportElement
x="0"
y="-6"
width="1"
height="1"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</line>
</band>
</groupFooter>
</group>
<group name="TARGET_ID" >
<groupExpression><![CDATA[$F{TARGET_ID}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle>
<reportElement
x="35"
y="0"
width="745"
height="20"
forecolor="#000000"
backcolor="#0099CC"
key="rectangle-1"
positionType="FixRelativeToBottom"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="35"
y="0"
width="100"
height="20"
forecolor="#000000"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{TARGET_ID}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="140"
y="0"
width="300"
height="20"
forecolor="#000000"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{TARGET_ID}]]></textFieldExpression>

</textField>
</band>
</groupHeader>
<groupFooter>
<band height="2" isSplitAllowed="true" >
<line direction="BottomUp">
<reportElement
x="0"
y="-5"
width="1"
height="1"
key="line"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</line>
</band>
</groupFooter>
</group>
<group name="PRODUCT_LINE" >
<groupExpression><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></groupExpression>
<groupHeader>
<band height="20" isSplitAllowed="true" >
<rectangle>
<reportElement
x="35"
y="0"
width="745"
height="20"
forecolor="#000000"
backcolor="#009999"
key="rectangle-2"
positionType="FixRelativeToBottom"/>
<graphicElement stretchType="NoStretch" pen="Thin"/>
</rectangle>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="35"
y="0"
width="100"
height="20"
forecolor="#000000"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{PRODUCT_LINE}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="140"
y="0"
width="300"
height="20"
forecolor="#000000"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></textFieldExpression>

</textField>
</band>
</groupHeader>
<groupFooter>
<band height="10" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="GROUP_LTU" >
<groupExpression><![CDATA[$F{LTU}]]></groupExpression>
<groupHeader>
<band height="0" isSplitAllowed="true" >
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="30" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
x="0"
y="0"
width="782"
height="1"
forecolor="#808080"
key="line"/>
<graphicElement stretchType="NoStretch" pen="2Point"/>
</line>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="0"
y="5"
width="782"
height="20"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">
<font fontName="Helvetica" pdfFontName="Helvetica" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{activation_report_title}]]></textFieldExpression>

</textField>
<line direction="TopDown">
<reportElement
x="0"
y="25"
width="782"
height="1"
forecolor="#808080"
key="line"/>
<graphicElement stretchType="NoStretch" pen="2Point"/>
</line>
</band>
</title>
<pageHeader>
<band height="0" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="45" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="50"
y="0"
width="100"
height="20"
key="staticText-1_FAMILY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{FAMILY}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="150"
y="0"
width="335"
height="20"
key="textField-1_FAMILY"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{LKP(FAMILY)PRODUCT_FAMILY_CODE}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="50"
y="20"
width="100"
height="20"
key="staticText-2_LTU"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="150"
y="20"
width="335"
height="20"
key="textField-2_LTU"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{LTU}]]></textFieldExpression>

</textField>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="40" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
x="0"
y="0"
width="782"
height="1"
key="line"/>
<graphicElement stretchType="NoStretch" pen="2Point"/>
</line>
<image scaleImage="FillFrame" isUsingCache="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
mode="Opaque"
x="0"
y="5"
width="140"
height="35"
key="image-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<graphicElement stretchType="NoStretch"/>
<imageExpression class="java.lang.String"><![CDATA[$R{image_ocs_logo}]]></imageExpression>

</image>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="145"
y="0"
width="200"
height="15"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Right">
<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="351"
y="0"
width="127"
height="15"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="607"
y="0"
width="69"
height="15"
key="textField-5"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{execution_date}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="679"
y="0"
width="101"
height="15"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>
<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="145"
y="15"
width="350"
height="10"
key="textField-3"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{disclaimer_line_1}]]></textFieldExpression>

</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement
x="145"
y="30"
width="350"
height="10"
key="textField-4"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$R{disclaimer_line_2}]]></textFieldExpression>

</textField>
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>'
;
INSERT INTO TEST VALUES(y);
INSERT INTO TEST
SELECT y FROM TEST ;
END;

Re: Unable to insert into CLOB column [message #185975 is a reply to message #185957] Fri, 04 August 2006 10:13 Go to previous message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi

Thanks for your help.

I have implemented as u mentioned..but still i am getting following errors.

ORA-06550: line 4, column 6:
PLS-00172: string literal too long


DECLARE
MSG CLOB;
BEGIN
MSG:='<?xml version="1.0" encoding="UTF-8"  ?> 
<!-- Created with iReport - A designer for JasperReports --> 
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport 
                 name="ActivatedLicAssetReportTemplate" 
                 language="java" 
                 columnCount="1" 
                 printOrder="Vertical" 
                 orientation="Portrait" 
                 pageWidth="842" 
                 pageHeight="595" 
                 columnWidth="782" 
                 columnSpacing="0" 
                 leftMargin="30" 
                 rightMargin="30" 
                 topMargin="20" 
                 bottomMargin="20" 
                 whenNoDataType="AllSectionsNoDetail" 
                 isTitleNewPage="false" 
                 isSummaryNewPage="false" 
                 resourceBundle="JasperReportsLocalization" 
                 whenResourceMissingType="Empty"> 
        <property name="ireport.scriptlethandling" value="0" /> 
        <property name="ireport.encoding" value="UTF-8" /> 
        <import value="java.util.*" /> 
        <import value="net.sf.jasperreports.engine.*" /> 
        <import value="net.sf.jasperreports.engine.data.*" /> 
        <parameter name="DataFile" isForPrompting="true" class="java.lang.String"/> 
        <parameter name="CompanyName" isForPrompting="true" class="java.lang.String"/> 
        <parameter name="CertStatus" isForPrompting="true" class="java.lang.String"/> 
        <field name="COMPANY_NAME" class="java.lang.String"/> 
        <field name="CITY" class="java.lang.String"/> 
        <field name="TARGET_ID" class="java.lang.String"/> 
        <field name="LKP(PRODUCT_LINE)PRODUCT_LINE" class="java.lang.String"/> 
        <field name="LKP(FAMILY)PRODUCT_FAMILY_CODE" class="java.lang.String"/> 
        <field name="LKP(COUNTRY)COUNTRY_CODE" class="java.lang.String"/> 
        <field name="EMAIL" class="java.lang.String"/> 
        <field name="LTU" class="java.math.BigDecimal"/> 
        <variable name="ltuGroupSum" class="java.math.BigDecimal" resetType="Group" incrementType="Group" incrementGroup="COMPANY_NAME" resetGroup="COMPANY_NAME" calculation="Sum">
                <variableExpression><![CDATA[$F{LTU}]]></variableExpression> 
        </variable> 
        <variable name="LtuSum" class="java.math.BigDecimal" resetType="Group" resetGroup="GROUP_LTU" calculation="Sum">
                <variableExpression><![CDATA[$F{LTU}]]></variableExpression> 
        </variable> 
                <group  name="COMPANY_NAME" > 
                        <groupExpression><![CDATA[$F{COMPANY_NAME}]]></groupExpression> 
                        <groupHeader> 
                        <band height="20"  isSplitAllowed="true" > 
                                <rectangle> 
                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="780" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#0066CC" 
                                                key="rectangle"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </rectangle> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-1_COMPANY_NAME"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{COMPANY_NAME}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="105" 
                                                y="0" 
                                                width="144" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-1_COMPANY_NAME"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{COMPANY_NAME}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="250" 
                                                y="0" 
                                                width="42" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-2_EMAIL"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{EMAIL}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="296" 
                                                y="0" 
                                                width="49" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-2_EMAIL"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{EMAIL}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="350" 
                                                y="0" 
                                                width="29" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-3_CITY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{CITY}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="381" 
                                                y="0" 
                                                width="149" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-3_CITY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{CITY}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="538" 
                                                y="0" 
                                                width="65" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField-4_COUNTRY_CODE"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{LKP(COUNTRY)COUNTRY_CODE}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="608" 
                                                y="0" 
                                                width="50" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText-5_LTU"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="COMPANY_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="665" 
                                                y="0" 
                                                width="50" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#FFCCCC" 
                                                key="textField-5_ltuGroupSum"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{ltuGroupSum}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="#0" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="COMPANY_NAME"  hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="719" 
                                                y="0" 
                                                width="50" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#FFCCCC" 
                                                key="textField-5_LtuSum"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.math.BigDecimal"><![CDATA[$V{LtuSum}]]></textFieldExpression>
                                </textField> 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="2"  isSplitAllowed="true" > 
                                <line direction="BottomUp"> 
                                        <reportElement 
                                                x="0" 
                                                y="-6" 
                                                width="1" 
                                                height="1" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </line> 
                        </band> 
                        </groupFooter> 
                </group> 
                <group  name="TARGET_ID" > 
                        <groupExpression><![CDATA[$F{TARGET_ID}]]></groupExpression> 
                        <groupHeader> 
                        <band height="20"  isSplitAllowed="true" > 
                                <rectangle> 
                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="745" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#0099CC" 
                                                key="rectangle-1" 
                                                positionType="FixRelativeToBottom"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </rectangle> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{TARGET_ID}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="140" 
                                                y="0" 
                                                width="300" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{TARGET_ID}]]></textFieldExpression>
                                </textField> 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="2"  isSplitAllowed="true" > 
                                <line direction="BottomUp"> 
                                        <reportElement 
                                                x="0" 
                                                y="-5" 
                                                width="1" 
                                                height="1" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </line> 
                        </band> 
                        </groupFooter> 
                </group> 
                <group  name="PRODUCT_LINE" > 
                        <groupExpression><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></groupExpression> 
                        <groupHeader> 
                        <band height="20"  isSplitAllowed="true" > 
                                <rectangle> 
                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="745" 
                                                height="20" 
                                                forecolor="#000000" 
                                                backcolor="#009999" 
                                                key="rectangle-2" 
                                                positionType="FixRelativeToBottom"/> 
                                        <graphicElement stretchType="NoStretch" pen="Thin"/> 
                                </rectangle> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="35" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="staticText"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{PRODUCT_LINE}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="140" 
                                                y="0" 
                                                width="300" 
                                                height="20" 
                                                forecolor="#000000" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{LKP(PRODUCT_LINE)PRODUCT_LINE}]]></textFieldExpression>
                                </textField> 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="10"  isSplitAllowed="true" > 
                        </band> 
                        </groupFooter> 
                </group> 
                <group  name="GROUP_LTU" > 
                        <groupExpression><![CDATA[$F{LTU}]]></groupExpression> 
                        <groupHeader> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                        </groupHeader> 
                        <groupFooter> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                        </groupFooter> 
                </group> 
                <background> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </background> 
                <title> 
                        <band height="30"  isSplitAllowed="true" > 
                                <line direction="TopDown"> 
                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="782" 
                                                height="1" 
                                                forecolor="#808080" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="2Point"/> 
                                </line> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="0" 
                                                y="5" 
                                                width="782" 
                                                height="20" 
                                                key="staticText"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement textAlignment="Center"> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{activation_report_title}]]></textFieldExpression>
                                </textField> 
                                <line direction="TopDown"> 
                                        <reportElement 
                                                x="0" 
                                                y="25" 
                                                width="782" 
                                                height="1" 
                                                forecolor="#808080" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="2Point"/> 
                                </line> 
                        </band> 
                </title> 
                <pageHeader> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </pageHeader> 
                <columnHeader> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </columnHeader> 
                <detail> 
                        <band height="45"  isSplitAllowed="true" > 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="50" 
                                                y="0" 
                                                width="100" 
                                                height="20" 
                                                key="staticText-1_FAMILY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{FAMILY}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="150" 
                                                y="0" 
                                                width="335" 
                                                height="20" 
                                                key="textField-1_FAMILY"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$F{LKP(FAMILY)PRODUCT_FAMILY_CODE}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="50" 
                                                y="20" 
                                                width="100" 
                                                height="20" 
                                                key="staticText-2_LTU"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{LTU}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="150" 
                                                y="20" 
                                                width="335" 
                                                height="20" 
                                                key="textField-2_LTU"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="12" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.math.BigDecimal"><![CDATA[$F{LTU}]]></textFieldExpression>
                                </textField> 
                        </band> 
                </detail> 
                <columnFooter> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </columnFooter> 
                <pageFooter> 
                        <band height="40"  isSplitAllowed="true" > 
                                <line direction="TopDown"> 
                                        <reportElement 
                                                x="0" 
                                                y="0" 
                                                width="782" 
                                                height="1" 
                                                key="line"/> 
                                        <graphicElement stretchType="NoStretch" pen="2Point"/> 
                                </line> 
                                <image  scaleImage="FillFrame" isUsingCache="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                mode="Opaque" 
                                                x="0" 
                                                y="5" 
                                                width="140" 
                                                height="35" 
                                                key="image-1"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <graphicElement stretchType="NoStretch"/> 
                                        <imageExpression class="java.lang.String"><![CDATA[$R{image_ocs_logo}]]></imageExpression>
                                </image> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="145" 
                                                y="0" 
                                                width="200" 
                                                height="15" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement textAlignment="Right"> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="351" 
                                                y="0" 
                                                width="127" 
                                                height="15" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                               <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="607" 
                                                y="0" 
                                                width="69" 
                                                height="15" 
                                                key="textField-5"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{execution_date}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="679" 
                                                y="0" 
                                                width="101" 
                                                height="15" 
                                                key="textField"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement> 
                                                <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="145" 
                                                y="15" 
                                                width="350" 
                                                height="10" 
                                                key="textField-3"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement textAlignment="Center"> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{disclaimer_line_1}]]></textFieldExpression>
                                </textField> 
                                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                                        <reportElement 
                                                x="145" 
                                                y="30" 
                                                width="350" 
                                                height="10" 
                                                key="textField-4"/> 
                                        <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                                        <textElement textAlignment="Center"> 
                                                <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />
                                        </textElement> 
                                <textFieldExpression   class="java.lang.String"><![CDATA[$R{disclaimer_line_2}]]></textFieldExpression>
                                </textField> 
                        </band> 
                </pageFooter> 
                <summary> 
                        <band height="0"  isSplitAllowed="true" > 
                        </band> 
                </summary> 
</jasperReport>';

insert into report_info_detail (REPORT_INFO_ID, REPORT_EXPORT_TYPE_CODE, PLUGIN_CLASS_NAME, IS_ACTIVE,REPORT_TEMPLATE) 
select r.report_info_id, 
        'pdf', 
        'com.ocs.poetic.reports.JRActivatedLicAssetReportPlugin', 
        -1,MSG
from report_info r where security_resource_name = 'ACTIVATED_LIC_ASSET_REPORT';
END;



Thanks
Previous Topic: Function Help
Next Topic: Oracle equivalent of SQL Server timestamp data type
Goto Forum:
  


Current Time: Fri Dec 09 21:06:12 CST 2016

Total time taken to generate the page: 0.07930 seconds