TCC/Taleo connect Client - Concatenation CLOB Data with Number/Integer data type

Summary

TCC/Taleo connect Client - Trying to Concatenate External Job description which is a CLOB data with Number/Integer data type

Content

Hi Team,

I wanted to concatenate External Job Description along with Number/Integer data type value based on a condition using TCC/Taleo Connect client.

Tried writing a complex projection, but export script failed to extract the data because of error "oracle.sql.CLOB@21bb663b".

Please suggest me how to achieve this requirement.

 

Thank You,

Manasa

Version

Recruting 17

Code Snippet

<quer:concatenate>
            <quer:field ownerQuery="MainQuery" path="Requisition,JobInformation,DescriptionExternalHTML"/>
            <quer:string></quer:string>
            </quer:concatenate>
          <quer:field ownerQuery="MainQuery" path="Requisition,JobInformation,DescriptionExternalHTML"/>