JDBC Adapter SP Oracle With Array Input

,
1

hi,

I have StoreProcedure in oracle with array input.

image
image850×597 18.2 KB

when i try to execute i have error like this

com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service test.aol:test1 with connection ad1.aol.core.conn:dbAolConn.
ClassCast Exception for field: P_ARRAY. Error: java.lang.ClassCastException: com.wm.adk.cci.record.WmRecord cannot be cast to [Ljava.lang.Object;

this my simple service to execute SP

image
image1217×743 41 KB

how to create input for my case? i hope someone can help

Regards,
momon

2

Hi Dekaa,

can you check which other types (beside of java.lang.Object) are available for the input field type in the lower half of the adapter service?

Please check if you have latest Fixes for JDBC Adapter applied, there are sometimes issues solved there in relation to SPs.

You might want to have a look at the JDBC Adapter Users Guide if there is a hint about arrays.

Regards,
Holger

3

hi holger,

thanks for your response

this input field type for adaptter service
java.lang.Object
IDATA_ARRAY
java.sql.Array
image

this jdbc fix JDBC_10.3_Fix11
image

where can i get the JDBC Adapter Users Guide?

regards,
Momon

4

Here you go -

  • JDBC Adapters (10.3) user guide is here (link)
  • More documents such as readme, for JDBC Adapter are here (link)
  • In general, all documentation is publicly available here (link)

KM

1 Like
5

Hi Dekaa,

in this case I would try either IDATA_ARRAY or java.sql.Array.

If none of these are working for your use case you should consider opening a support ticket via Empower eService to get this checked.

Regards,
Holger

6

Yes either of the above InputFieldType- array’s selection (mainly sql.Array) should suffice to the calling SP for successful execution.

HTH,
RMG

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.