execute stored procedures in XI

[Former Member]

Hi Friends,

Can anyone plz tell me how to execute a stored procedure in XI.

What is the syntax that should be specified in the JDBC Sender Adapter in ID.

I have given EXEC ProcedureName and EXECUTE ProcedureName.

But this doesn't work. And the same command works in Oraclq sql plus.

What is the correct Syntax.

[Former Member]

Hi Narayana

You will need to create a datatype abiding with the following schema for stored procedure,

<root>

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

</root>

as explained in the following link,

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

I picked up a sample datatype example from an alternate thread, hope it helps you in creating a similar datatype for your requirement,

Re: Using SQL stored procedure in XI 3.0

Posted: Apr 26, 2005 4:47 PM Click to reply to this topic Reply E-mail this post E-mail this post

sample datatype:

<?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>

cheers

Sameer

[Former Member]

HI

Thanks for the Reply.

But Iam using JDBC Sender and I want to retrive data from Oracle database by executing the stored procedure in the JDBC Sender. And if I give EXEC or EXECUTE in JDBC Sender, it says invalid SQL statement.

So how is the datatype provided by you is helpful to me?

[MichalKrawczyk]

Hi,

try this weblog:

JDBC Stored Procedures

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards,

michal