Stored Procedure Plugin

Hi All,

I have a requirement to store CLOB data type in a Database table "TABLE1" where one column is of type CLOB. I did not see a direct solution for this . I decided to work with Execute Stored Procedure plugin for this

I have a stored procedure where is one  IN Parameter is of type "TYPE" of the same table where one CLOB column is present but when I am trying to run the SP from Appian it gives me 

"java.sql.SQLException: Invalid column type" exception in this IN Column. In Appian I have configure this INPUT Type parameter as the same CDT which is linked with the "TABLE1" . I have mapped this as multiple type

 

Does some one help me on this.

Thanks-

Ruchi

  Discussion posts and replies are publicly visible

Parents
  • Hi Ruchi, Is there any specific requirement to create clob type field as multiple in cdt?.

    If it is single type than just download xsd and type columndefination as clob to map with table column

    <xsd:element name="columnName" nillable="true" type="xsd:string">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">@Column(name="column_name", columndefination="clob")</xsd:appinfo>
    </xsd:annotation>
    </xsd:element>

    If we create it as multiple type than it will create a new table for that particular field

Reply
  • Hi Ruchi, Is there any specific requirement to create clob type field as multiple in cdt?.

    If it is single type than just download xsd and type columndefination as clob to map with table column

    <xsd:element name="columnName" nillable="true" type="xsd:string">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">@Column(name="column_name", columndefination="clob")</xsd:appinfo>
    </xsd:annotation>
    </xsd:element>

    If we create it as multiple type than it will create a new table for that particular field

Children
No Data