Skip to Content
0
Former Member
Mar 22, 2006 at 06:13 AM

JDBC Stored Procedure problem

95 Views

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.