JDBCAdapter Stored Procedure With Signature for STRUCT as IN & OUT Parameter Type

, ,
1

Hi All,

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.

Regards,
gayathri

2

Not sure if that is supported part of SP template.

BTW what is your IS version and also JDBC Adapter fix level on?

Please touch base with SAG support also and they can point you in the right direction.

HTH,
RMG

3

Thanks for the response…

IS Version : 8.0

JDBC Adapter Version : 6.5

Database : Oracle 11g

For the Struct IN & Out Parameters what type of conversion is used in the services…

4

Please check with your SQL DBA or what JDBC Field type you choose in the selection of the Adapter AS for SP?

HTH,
RMG

5

Hi,

while invoking the Stored Procedure with Signature in the service,in the Pipeline tab for Service In & Service Out for the Adapter we are getting as Object since the .

How the Object to the variables in the Pipeline In can be mapped…

And when we Run the Service we are getting the following error
Adapter Runtime (Adapter Service): Unable to invoke adapter service…Could anyone help on this…

Suggestions would be appreciated…

Regards,
gayathri