on 07-17-2016 12:21 PM
I am trying to create a Stored Procedure universe in SAP BO 4.2 but it’s showing below error,
Below are the steps that I have followed to create a Stored Procedure universe.
Using Quick Wizard ->Click here to choose Store Procedure universe->Entered Universe Name, New Database Connection->I was able to see available SP's.
I selected one SP-> Add->In Stored Procedure Editor it was asking for Enter parameter value.
I enabled parameter Stored_Proc_Universe as Yes.
But it was throwing below error:
Exception:DBD,ORA-06550:line 1,column 8:
PLS-00306:wrong number or types of arguments in call to 'SP_BO_TEST'
ORA-06550:line 1, column 8:
PL/SQL: Statement ignored
State: N/A
Please can someone help me to resolve this issue.
Hi Ravi,
Are you able to run the Stored Procedure directly in Oracle?
There are some restrictions on which types of stored procedure are supported in BO.
You can refer the following article for the same: Stored Procedure Universe Best Practice Guide - Business Intelligence (BusinessObjects) - SCN Wiki
Hope it helps!
Regards,
Adil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Adil,
Thanks for your reply.
I only created the Stored Procedure and I am able to run it directly in Oracle.
It has been created with one IN parameter and one OUT parameter as Ref Cursor and also I have created one more Stored Procedure only with Ref Cursor (OUT - Parameter) but when I try to access any of the existing Procedures along with these two procedures it's throwing an below error.
Exception: DBD, ORA-06550: line 1, column 8:
PLS-00306: wrong number or types of arguments in call to 'BO_TEST' - (Stor Proc name).
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
State: N/A
Please can you help me with this error.
Many thanks,
Ravi
Hi Ravi,
The stored procedures do not support OUT or dynamic result sets parameters in UDT.
You can refer the following link for best practices: Stored Procedure Universe Best Practice Guide - Business Intelligence (BusinessObjects) - SCN Wiki
Regards,
Adil Raj
Hi Adil,
Thanks for your response.
We are able to call all type of stored procedures in Deski (3.1) but in 4.2 there is a note that we can call stored procedures directly through webi but we are unable to call stored procedures in Webi as well as through UDT.
It's latest version (4.2) and there should be some extra options and flexibilities when we compare to older version (3.2) but it's not even working as older version in terms of calling stored procedures.
Any idea.
Thanks and regards,
Ravi
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.