When i call Procedure from Oracle ERP in JDBC Stored procedure with Signature,Procedures are not being loaded continuosly for STRUCT as both IN & OUT Parameter Type.
I am having a procedure as below
PROCEDURE order_attachment_prc (
p_en_header_t IN gemom_eni_po_ord_hdr_t,
p_en_line_t_tbl IN gemom_eni_po_ord_ln_tbl,
p_header_id IN NUMBER
when i configure the above procedure in the Adapter SP in Call the values are being loaded as below
Parameter Name SQL TYPE JDBC TYPE Parameter type Expression
P_EN_HEADER_T GEMOM_ENI_PO_ORD_HDR_T STRUCT IN ?
P_EN_LINE_T_TBL GEMOM_ENI_PO_ORD_LN_TBL STRUCT IN ?
OBJECT OTHER IN ?
P_HEADER_ID NUMBER DECIMAL IN ?
I am getting inbetween value for SQL TYPE as Object & Empty for Paramter Name.
Please Suggest the solution.
Thanks in Advance.