Using SQL stored procedure in XI 3.0

[Former Member]

I'm using XI 3.0

I have the stored procedure below,

How can I prepare Datatype to execute this stored procedure

Thanks

CREATE PROCEDURE VENDOR_INSERT

(

@VendorNumber VARchar(10),

@LastName VARchar(15)

)

AS

INSERT INTO Vendor01(VendorNumber,LastName) VALUES(@VendorNumber,@LastName)

GO

[Former Member]

Hi Sujatha,

Tanks for your help

I'have that document, I examined that document and prepared DataType again and again.But every test was fail.

There is sample message type below that I tested

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

<ns0:VendorMaster_insert_SPMT xmlns:ns0="http://borcelik.com/tbit40/base">

<SP_EXECUTE>

<VENDOR_INSERT action="EXECUTE">

<VendorNumber type="VARCHAR(10)">12345678</VendorNumber>

<LastName type="VARCHAR(15)">Bozlagan</LastName>

</VENDOR_INSERT>

</SP_EXECUTE>

</ns0:VendorMaster_insert_SPMT>

I need an example DataType

Thanks.

[Former Member]

Here is my sample datatype that solved my problem:

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

<MT_Employee_Procedure>

<root>

<qryEmployee action="EXECUTE">

<table>TOTS_PROCEDURES.qryEmployee</table>

<pUserID isInput="true" type="VARCHAR">helps</pUserID>

<pEmployee isOutput="true" type="VARCHAR">empty</pEmployee>

</qryEmployee>

</root>

</MT_Employee_Procedure>

This produced the result:

<MT_Employee_Procedure_response>

<root_response>

<pEmployee>Help, Samuel R.</pEmployee>

</root_response>

</MT_Employee_Procedure_response>

The Data types will correspond to the xmls above by reading the article http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

[Former Member]

hi cemil,

you need the format of Datatype for stored procedures.

kindly go through this link..i think it will give the answer to your query

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

regards,

Sujatha