AnsweredAssumed Answered

Object type as parameter in oracle database

Question asked by dmeka326288 on Apr 23, 2018

Hi,

I need to call a Oracle stored procedure from Boomi using Oracle E-Business Suite. This procedure has Object type as input parameter. When I tried running the Boomi process in TEST mode I get the following error

 

Embedded message: com.boomi.connector.api.ConnectorException: Error executing Oracle EBS Command: Exception Description: The object [MSC_SDC_MESSAGE_TYPE], of class [class java.lang.String], could not be converted to [class java.lang.Class]. Ensure that the class [MSC_SDC_MESSAGE_TYPE] is on the CLASSPATH. You may need to use alternate API passing in the appropriate class loader as required, or setting it on the default ConversionManager Internal Exception: java.lang.ClassNotFoundException: MSC_SDC_MESSAGE_TYPE: Exception [EclipseLink-3007] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.ConversionException Exception Description: The object [MSC_SDC_MESSAGE_TYPE], of class [class java.lang.String], could not be converted to [class java.lang.Class]. Ensure that the class [MSC_SDC_MESSAGE_TYPE] is on the CLASSPATH. You may need to use alternate API passing in the appropriate class loader as required, or setting it on the default ConversionManager Internal Exception: java.lang.ClassNotFoundException: MSC_SDC_MESSAGE_TYPE; Caused by: Error executing Oracle EBS Command: Exception Description: The object [MSC_SDC_MESSAGE_TYPE], of class [class java.lang.String], could not be converted to [class java.lang.Class]. Ensure that the class [MSC_SDC_MESSAGE_TYPE] is on the CLASSPATH. You may need to use alternate API passing in the appropriate class loader as required, or setting it on the default ConversionManager Internal Exception: java.lang.ClassNotFoundException: MSC_SDC_MESSAGE_TYPE: Exception [EclipseLink-3007] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.ConversionException Exception Description: The object [MSC_SDC_MESSAGE_TYPE], of class [class java.lang.String], could not be converted to [class java.lang.Class]. Ensure that the class [MSC_SDC_MESSAGE_TYPE] is on the CLASSPATH. You may need to use alternate API passing in the appropriate class loader as required, or setting it on the default ConversionManager Internal Exception: java.lang.ClassNotFoundException: MSC_SDC_MESSAGE_TYPE; Caused by: Exception Description: The object [MSC_SDC_MESSAGE_TYPE], of class [class java.lang.String], could not be converted to [class java.lang.Class]. Ensure that the class [MSC_SDC_MESSAGE_TYPE] is on the CLASSPATH. You may need to use alternate API passing in the appropriate class loader as required, or setting it on the default ConversionManager Internal Exception: java.lang.ClassNotFoundException: MSC_SDC_MESSAGE_TYPE; Caused by: MSC_SDC_MESSAGE_TYPE

 

Can somebody suggest is there way to call the procedure with Object Type or a work around to get this running in Boomi.

Your inputs are much appreciated.

 

Thanks,

Devi Meka.

Outcomes