Skip to Content
Jun 09, 2014 at 09:26 PM

Error when trying to invoke a Synchronous Stored Procedure on Oracle


Hi Experts,

I am trying to invoke a Synchronous Proxy in Oracle from SAP PI.

This is the request XML that is generated.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:Price_Order_Request_MT xmlns:ns0="http://XXXXXXXXXXXXXXX/StoredProcedure">

- <Statement>



<LINECNT isInput="true" type="INTEGER">1</LINECNT>

<CUSTOMER_ID isInput="true" type="VARCHAR">0000001234</CUSTOMER_ID>

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

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

<PRICE_DATE isInput="true" type="TIMESTAMP">2014-05-13 00:00:00</PRICE_DATE>

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

<SALES_ORG_ID isInput="true" type="VARCHAR">5004</SALES_ORG_ID>




But i get the following error. Error processing request in sax parser: Error when executing statement for table/stored proc. 'WRAPPER_HSP_PRICE_ORDER' (structure 'Statement'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'WRAPPER_HSP_PRICE_ORDER' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

I have searched through the forums, but could not find a definitive answer.

Best Regards,

Ravikanth Talagana