JDBC problem:
i am trying to execute the storedprocedure which has got 3 parameters(2 input and 1 output). I created the following data type:
Request data type:
DT_jdbc_update
-->StatementName
-->storedProcedureName
action (EXECUTE)
table (Actual storedprocedure name)
-->PvSapDoc
isInput (true)
type (CHAR)
-->PvAmountSap
isInput (true)
type (CHAR)
Response data type:
DT_jdbc_update_response
-->statementName_response
-->row
-->pvRETURN
isOutput (true)
type (CHAR)
But when i am trying to execute the scenario, getting this error:
com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table
/stored proc. 'ProcSAPSPDFICO086' (structure 'StatementName'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306:
wrong number or types of arguments in call to 'PROCSAPSPDFICO086' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Am i doing any mistake in request data type parameters as it's saying that wrong number arguments.
Just for the information here is the storedprocedure code:
_________
CREATE OR REPLACE PROCEDURE ProcSAPSPDFICO086(PvSapDoc VARCHAR2,
PnAmountSap VARCHAR2,
pvRETURN out VARCHAR2)
IS BEGIN
UPDATE AHMFASPD_TEMPREQS
SET VNODOC = PvSapDoc,
NAMOUNTSAP = PnAmountSap
WHERE VID = 'FICO086';
EXCEPTION
WHEN OTHERS THEN
pvRETURN := 'error SAPSPDFICO086 update AHMFASPD_TEMPREQ ';
END;
________
How can i resolve this...??
Quick response is higly appreciable.