Stored Procedure call to Oracle - issue

[Former Member]

hi ,

I am trying to call a receiver JDBC adapter to call an oracle stored procedure -

I got this error ->

java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call - which I understand is related to mismatch btw the XML and Stored procedure

I checked the XMl and it matches the stored procedure call. I have two specific questions -

1) I have used SAP Note 801367 to have a look at the SQl command sent to the db.. However I do not see the stored procedure in the Audit logs...Does this feature work for Stored procedures too?

2) Can you look at the XML sent to the JDBC adapter...I saw something wierd... even though I had declared the isOutput attribute first and then attribute type... when I loaded the MT into the mapping the order changed...Does than matter?

<customer_id isInput="true" type="VARCHAR">5000123</customer_id>

<product_id isInput="true" type="VARCHAR">0041003</product_id>

<serial_number isInput="true" type="VARCHAR">1</serial_number>

<effective_date isInput="true" type="VARCHAR">2010-03-16</effective_date>

<quantity isInput="true" type="NUMERIC">1.000</quantity>

<currency_code isInput="true" type="VARCHAR">USD</currency_code>

<dist_channel_id isInput="true" type="VARCHAR">11</dist_channel_id>

<division_id isInput="true" type="VARCHAR">04</division_id>

<org_unit_id isInput="true" type="VARCHAR">1005</org_unit_id>

<config_name isInput="true" type="VARCHAR" />

<resolved_price type="NUMERIC" isOutput="true" />

<resolved_currency type="VARCHAR" isOutput="true" />

<contract_id type="VARCHAR" isOutput="true" />

<contract_desc type="VARCHAR" isOutput="true" />

<contract_owner_id type="VARCHAR" isOutput="true" />

<payment_terms type="VARCHAR" isOutput="true" />

<product_group_id type="VARCHAR" isOutput="true" />

<commitment_id type="VARCHAR" isOutput="true" />

<tier_index type="VARCHAR" isOutput="true" />

<shipping_flag type="VARCHAR" isOutput="true" />

<result_code type="VARCHAR" isOutput="true" />

<exec_time type="NUMERIC" isOutput="true" />

java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call

[Former Member · Accepted solution]

Arvind,

Just to be sure: are all inputs to yourstored procedure of type varchar, or are there maybe inputs with different types?

A mismatch between the type specified in the XML and the expected inputs of the SP can also cause this error.

Regards,

Koen

[Former Member]

Any help would be appreciated...