Function Getclobval() Return Miscellaneous Results (Doc ID 1355725.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

The function getclobval return various results. When it is called first time return CLOB with smaller length as any other time. This causes errors when we use this function to read CLOB. For example, for XML like:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="html" />
<xsl:template match="params">
 <h4>Mo?né dodatky</h4>
 <table border="1">
  <th ALIGN="center" COLSPAN="1" style="padding-left: 2px">Èíslo zmluvy</th>
  <th ALIGN="center" COLSPAN="2" style="padding-left: 2px">Telefónne èísla na zmluve</th>
  <th ALIGN="center" COLSPAN="1" style="padding-left: 2px">Typ dodatku</th>
  <th ALIGN="center" COLSPAN="1" style="padding-left: 2px">Detailny pohžad na výsledky</th>

  <xsl:for-each select="contract_no">
   <xsl:for-each select="sn">
    <tr>
     <xsl:if test="position()=1">
       <td ALIGN="left" rowspan="{../sn_cnt}"><xsl:value-of select="../value" /></td>
     </xsl:if>
     <td ALIGN="left" COLSPAN="1"><INPUT TYPE="checkbox" NAME="x_position" VALUE="{ch_id}" /></td>
     <td><xsl:value-of select="value" /></td>
     <td ALIGN="left">
      <xsl:choose>
       <xsl:when test="st">
        <xsl:for-each select="st">
         <xsl:value-of select="val"/>
         <xsl:if test="position()!=last()">,</xsl:if>
        </xsl:for-each>
       </xsl:when>
       <xsl:otherwise>
        Nepovolená
       </xsl:otherwise>
      </xsl:choose>
      <xsl:if test="excepts">
        <br />Výnimka na dodatky: <b>
        <xsl:for-each select="excepts/value">
         <xsl:value-of select="."/>
         <xsl:if test="position()!=last()">,</xsl:if>
        </xsl:for-each></b>
      </xsl:if>
      <xsl:if test="storno_disconn">
       <br /><font color="red">existuje po?iadavka na odpojenie</font>
      </xsl:if>
     </td>
     <td ALIGN="left"><input type="button" onClick="f_showDetail({ch_id})" value="Dôvody" /></td>
    </tr>
   </xsl:for-each>
  </xsl:for-each>
 </table>
 <xsl:if test="contract_no/storno_buttons">
  <br />
  <input type="button" onClick="f_prStorno();" value="?iados? o storno výpovede Zmluvy" />
  <input id="xButtonStorno" name="xButtonStorno" type="submit" value="Stornuj výpoveï Zmluvy" disabled="true" />
  <br />
 </xsl:if>
</xsl:template>
</xsl:stylesheet>

It will return:
<h4>Mo?né dodatky</h4><table border="1"><th ALIGN="center" COLSPAN="1"
style="padding-left: 2px">Číslo zmluvy</th><th ALIGN="center" COLSPAN="2"
style="padding-left: 2px">Telefónne čísla na zmluve</th><th ALIGN="center"
COLSPAN="1" style="padding-left: 2px">Typ dodatku</th><th ALIGN="center"
COLSPAN="1" style="padding-left: 2px">Detailny pohad na výsledky</th><tr><td
ALIGN="left" rowspan="1">00618431</td><td ALIGN="left" COLSPAN="1"><INPUT
TYPE="checkbox" NAME="x_position"
VALUE="8245253"></INPUT></td><td>0905262111</td><td ALIGN="left">

Nepovolená
      </td><td ALIGN="left"><input type="button"
onClick="f_showDetail(8245253)" value="Dôvody"></input></td></tr></table>
Length=687
-------------------
-------------------
<h4>Mo?né dodatky</h4>
<table border="1">
 <th ALIGN="center" COLSPAN="1"
style="padding-left: 2px">Číslo zmluvy</th>
 <th ALIGN="center" COLSPAN="2"
style="padding-left: 2px">Telefónne čísla na zmluve</th>
 <th ALIGN="center"
COLSPAN="1" style="padding-left: 2px">Typ dodatku</th>
 <th ALIGN="center"
COLSPAN="1" style="padding-left: 2px">Detailny pohad na výsledky</th>
 <tr>

<td ALIGN="left" rowspan="1">00618431</td>
   <td ALIGN="left" COLSPAN="1">

<INPUT TYPE="checkbox" NAME="x_position" VALUE="8245253"/>
   </td>

<td>0905262111</td>
   <td ALIGN="left">
       Nepovolená
      </td>

<td ALIGN="left">
     <input type="button" onClick="f_showDetail(8245253)"
value="Dôvody"/>
   </td>
 </tr>
</table>

Length=743
-------------------
-------------------
<h4>Mo?né dodatky</h4>
<table border="1">
 <th ALIGN="center" COLSPAN="1"
style="padding-left: 2px">Číslo zmluvy</th>
 <th ALIGN="center" COLSPAN="2"
style="padding-left: 2px">Telefónne čísla na zmluve</th>
 <th ALIGN="center"
COLSPAN="1" style="padding-left: 2px">Typ dodatku</th>
 <th ALIGN="center"
COLSPAN="1" style="padding-left: 2px">Detailny pohad na výsledky</th>
 <tr>

<td ALIGN="left" rowspan="1">00618431</td>
   <td ALIGN="left" COLSPAN="1">

<INPUT TYPE="checkbox" NAME="x_position" VALUE="8245253"/>
   </td>

<td>0905262111</td>
   <td ALIGN="left">
       Nepovolená
      </td>

<td ALIGN="left">
     <input type="button" onClick="f_showDetail(8245253)"
value="Dôvody"/>
   </td>
 </tr>
</table>

Length=743


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms