Can ConnectIt accept CLOBs?

[moonpie]

Connect-IT will not accept clobs under anyway that I can configure it.
The details:
I have a scenario with a database connector going to a ServiceCenter connector. In that scenario I have on the database side a CLOB datatype that I am trying to match with an array of strings on the ServiceCenter connector.
DATABASE CONNECTOR:
Datasource(ODBC Driver) = "Oracle in OraHome 920" ( I tried the "Microsoft ODBC Driver for Oracle v2" as that said it was compatible with clobs but that driver would not even see CLOBS in the document type description of the table.)
With the above listed ODBC driver. I can setup the scenario and run it. If the amount of data in the CLOB does not exceed 255 characters then the data is brought over with no problems. HOWEVER, if the data exceeds that number of characters then only the first 255 are brought over and I get an error that says… "Unable to recover truncated memo "EJ_BR_COM_TXT" from table "EJSTAGINGSM1" in full because the table does not have a primary key."
I already thought of and tried to break the data down in the mapping by way of a global function. When I looked at the produced document type that came from the database connector only the first 255 chars of the data that was placed in the clob was placed in the produced document type of the database connector. Which leads me to believe that Connect-IT is not able to pick up all the data from the table.
Any help would be appreciated, moonpie

[moonpie]

Has anyone ever worked with a CLOB in Oracle?
I have two set up and ConnectIt writes to one of them, but cannot seem to write to the other. Both are set up the same varchar2(255) as an 'a' table. DBA states both tables are identical. Can't seem to understand why ConnectIT can map to one and not the other without truncating the data.