Hello,
I am facing issue while invoking DB procedure from SOA.
I have a procedure which will take input from SOA and will return multiple values to SOA.
The return is a record TYPE( TABLE TYPE).
and from SOA we are invoking this through DB adaptor.
But I am getting the below error. Can anyone help me to find the issue:
JCA Binding execute of Reference operation 'InvokeGetProductData' failed due to: Object XML conversion error.
An error occurred while converting a Java object to XML.
Unable to convert the XSD element PO_OUTPUT_DATA whose JDBC type is ARRAY to a corresponding XML document element. Cause: java.sql.SQLException: ORA-12592: TNS:bad packet
Here PO_OUTPUT_DATA is the output variable of the procedure.
and this is below TYPE.
TYPE Business_data_output_Record
IS RECORD
(item_no item_s.item_no%TYPE,
lang_code item_name_l_s.lang_code%type,
item_name item_s.item_name%TYPE,
item_name_2 item_s.item_name%TYPE,
unit_name item_attribute_s.unit_name%TYPE,
item_state item_s.item_state%TYPE);
TYPE Business_data_output_Rec_type IS TABLE OF Business_data_output_Record INDEX BY BINARY_INTEGER;