Skip to Content
author's profile photo Former Member
Former Member

Unable to create Universe with oracle stored procedure

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 07:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.