There is no explicit feature available in BO XI R2 designer to include stored procedures in a universe. So we can not run multiple out put parameter stored procedures, but we can run or include a u2018Stored procedureu2019 with single out put parameter in a universe.
BO XI 3.0/3.1 has an explicit feature to create stored procedure universes, where we can use multiple out put parameter stored procedure at universe level
XIR2 Limitation: The object definition will support only select statement
Workaround:
Follow the steps to use a stored procedure at universe level
1) Create a Stored Procedure in Data Base
2) Call the Stored Procedure with a Function
3) Call that function in the Universe Designer Object Definition
4) Use that Object to run a Stored Procedure
Ex:
Sample Stored Procedure Code:
Create or replace procedure pps(enam In char,tem OUT char)
IS
BEGIN
while enam='SMITH'
loop
tem:='EMPLOYEE';
end loop;
END pps;
/
Sample Function Code:
Create or replace FUNCTION CRS(a_devise2 IN char)return varchar2
IS
toto varchar2(20) ;
BEGIN
PPS(a_devise2 ,toto );
return toto ;
END CRS;
/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.