Increase character limit to 500 for fields of type String

SQL  VARCHAR(500)

# MODIFY 'reasonforrequest' ON 'cstickets' TO VARCHAR(500)

com.tommybahama.system.update.schema.3=ALTER TABLE cstickets MODIFY COLUMN p_reasonforrequest VARCHAR(500)

# MODIFY 'actionneeded' ON 'cstickets' TO VARCHAR(500)

com.tommybahama.system.update.schema.4=ALTER TABLE cstickets MODIFY COLUMN p_actionneeded VARCHAR(500)

Oracle VARCHAR2(500)

# MODIFY 'reasonforrequest' ON 'cstickets' TO VARCHAR2(500)

com.tommybahama.system.update.schema.3=ALTER TABLE cstickets MODIFY COLUMN p_reasonforrequest VARCHAR2(500)

# MODIFY 'actionneeded' ON 'cstickets' TO VARCHAR2(500)

com.tommybahama.system.update.schema.4=ALTER TABLE cstickets MODIFY COLUMN p_actionneeded VARCHAR2(500)

<attribute type="java.lang.String" qualifier="reasonForRequest">

     <persistence type="property">

<columntype database="oracle">

<value>varchar2(500)</value>

</columntype>

<columntype>

<value>varchar(500)</value>

</columntype>

</persistence>

     <modifiers optional="false" read="true" write="true"

      search="true" />

     <description>Reason For Request</description>

    </attribute>

    <attribute type="java.lang.String" qualifier="actionNeeded">

     <persistence type="property">

<columntype database="oracle">

<value>varchar2(500)</value>

</columntype>

<columntype>

<value>varchar(500)</value>

</columntype>

</persistence>

# MODIFY 'totaltaxvalues' ON 'cartentries' TO VARCHAR(500)
com.tommybahama.system.update.schema.1=ALTER TABLE cartentries MODIFY TaxValues VARCHAR2(500)

# MODIFY 'totaltaxvalues' ON 'orderentries' TO VARCHAR(500)
com.tommybahama.system.update.schema.2=ALTER TABLE orderentries MODIFY TaxValues VARCHAR2(500)


# MODIFY 'totaltaxvalues' ON 'cartentries' TO VARCHAR(500)
com.tommybahama.system.update.schema.1=ALTER TABLE cartentries MODIFY p_taxvaluesinternal VARCHAR(500)

# MODIFY 'totaltaxvalues' ON 'orderentries' TO VARCHAR(500)
com.tommybahama.system.update.schema.2=ALTER TABLE orderentries MODIFY p_taxvaluesinternal VARCHAR(500)


<attribute type="java.lang.String" qualifier="reasonForRequest">
     <persistence type="property">
      <columntype database="oracle">
       <value>varchar2(500)</value>
      </columntype>
      <columntype>
       <value>varchar(500)</value>
      </columntype>
     </persistence>
     <modifiers optional="false" read="true" write="true"
      search="true" />
     <description>Reason For Request</description>
    </attribute>
    <attribute type="java.lang.String" qualifier="actionNeeded">
     <persistence type="property">
      <columntype database="oracle">
       <value>varchar2(500)</value>
      </columntype>
      <columntype>
       <value>varchar(500)</value>
      </columntype>
     </persistence>