on 02-24-2011 6:16 AM
Hello,
I've read Chapter 7 - "Creating stored procedure universes" from the XI 3.1 Universe Designer Guide.
However, I haven't found what I was looking for, namely how does it actually work.
Also, it is not entirely clear for me what kind of parameters can be sent by BO and how to do this.
Can someone explain it to me, please.
Thanks
Hi,
The manual is actually pretty good in this area ...
Anyway - The stored procedures universe can only be used to call stored procedures - so It is an additional universe to your existing ones you have. The parameters the manual is talking about is the input/ouput parameters of the STORED PROCEDURE !!!! not the universe query.
Hope it helps....
Eran.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sands, Eran
thank you for your answers
Regards,
Cate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi cate,
We can only select the input parameter for the stored procedure, this parameter is created in the stored procedure itself, we just select the values for it.
The Stored procedure universe can have multiple input parameters.
The value which we select for the input parameter is passed to the stored procedure and it retrieves the records/resultset accordingly.
Input parameter is nothing but the prompt created at stored Procedure level.
For eg. "Enter EmpNo"
Hope it helps.
Thanks,
Sands
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.