Calling Oracle stored procedure from xMII Query Templates.

[Former Member]

Hi All,

We have a requirement to call a Oracle stored procedure from xMII, the SP expects some inputs and then it returns multiple rows.

I tried different approches with no results, I remember some posts on the same topic but I could not get in search results.

Looking for some help in this regards

Rupesh.

[Former Member]

Hi Rupesh,

jus write the following in ur query template -

CALL StoredProcedure_name([Param.1])

Regards,

Anil

[Former Member]

Hi Rupesh,

Just execute your stored procedure from SQL Server, you will get the code in new sql query tab.

Copy that paste in fixed query.

usually it will be like below example

Exec SPname

@var1 val,

@var2 val2;

var1 and var2 are the two param names that you will be passing to SP.

Regards,

Padma

[Former Member]

Hi Rupesh Bajaj,

In oracle stored procedure we have to use Packages..if you used packages the u have to assign to some variable.

To calling Stored procedure in Query Template is CALL Testing('Param.1','Param.2',,:X)

In above line Testing is Stored procedure name and Param.1,Param.2 is in Squre Brackets and X is Package.

Thanks

Ravilla Ramesh

[Former Member]

Hi Rupesh Bajaj,

In oracle stored procedure we have to use Packages..if you used packages the u have to assign to some variable.

To calling Stored procedure in Query Template is CALL Testing('[Param.1]','[Param.2]',,:X)

In above line Testing is Stored procedure name and Param.1 is parameters and X is Package.

Thanks

Ravilla Ramesh

[Former Member]

Hi Rupesh Bajaj,

In oracle stored procedure we have to use Packages..if you used packages the u have to assign to some variable.

To calling Stored procedure in Query Template is CALL Testing('[Param.1]','[Param.2]',,:X)

In above line Testing is Stored procedure name and Param.1 is parameters and X is Package.

Thanks

Ravilla Ramesh

[Former Member]

Hi Rupesh

Have you go through this thread:

https://forums.sdn.sap.com/click.jspa?searchID=24365489&messageID=5264693

I have worked on SQL Stored Procedure. I have called like this.

[abesh]

Hi Rupesh,

Did you try using the FixedQueryWithOutput Mode of the SQl Connector ?

Refer this help doc page : [http://help.sap.com/saphelp_xmii115/helpdata/en/Connectors/IDBCConnector.htm|http://help.sap.com/saphelp_xmii115/helpdata/en/Connectors/IDBCConnector.htm]

Best

Abesh