on 04-02-2009 9:11 AM
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.
Hi Rupesh,
jus write the following in ur query template -
CALL StoredProcedure_name([Param.1])
Regards,
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.