document to clob xml

, ,
1

What is the easiest way to convert idata document to clob object (in oracle db)? My idea below:
Document->pub.xml:documentToXMLString->myOwnJavaService->clobe (xml)

I have clob input in my jdbc storedProcedure adapter, and simple conversion by the line string → clob, doesn’t work.

2

For the clob type are you trying to set java.lang.string in the JDBC Field type on the adapter service and it didn’t work?

HTH,
RMG

3

It works fine with storedProcedureWithSignature, but not with storedProcedure adapter.

4

What is the error you are getting any more details on that?

5

I can’t debug over db function code (no grants on db), but I think It might be a problem with type conversion.

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service tests:invokeAdapterService.
[ADA.1.541] Cannot execute the SQL statement "? = call SchemaOne.packageOne.INVOKE_ADAPTER_SERVICE (?, ?, ?) ". "
(72000/12899) ORA-12899: value too large for column “SchemaOne”.“ADAPTER_SERVICE”.“INPUT_XML” (actual: 2836, maximum: 2000)
ORA-06512: at line 1
"

INPUT_XML length = 279

6

OK…What JDBC field type have you chosen on the adapter service for CLOB type?

HTH,
RMG

7

Both adapters
Input type String

storedProcedure
Param JDBC type == CLOB

storedProcedureWithSignature
SQL Type == CLOB
JDBC Type == CLOB