Skip to Content

Stored procedure using Universe design tool 4.2. Back end database being Oracle 12c

Hi All,

Scenario: Trying to use the Stored procedure using Universe design tool 4.2. Back end database being Oracle 12c. Detailed information is attached below.

BI platform version: SAP 4.2 SP2

Database: Oracle 12c (64 bit)

Database drivers: Ora client 12Home2 (64 bit)

SAMPLE STORED PROCEDURE:

create or replace PROCEDURE TABLE_UPDATE

(

V_EMPLOYEE IN EMP.EMPNO%TYPE,

V_SALARY IN EMP.SAL%TYPE

)

AS

emp_row EMP%rowtype;

BEGIN

SELECT EMPNO ,ENAME ,JOB ,MGR ,HIREDATE ,SAL ,COMM ,DEPTNO into emp_row from emp where empno=V_EMPLOYEE FOR UPDATE;

UPDATE EMP

SET

SAL = V_SALARY

WHERE EMPNO = V_EMPLOYEE ;

COMMIT ;

END TABLE_UPDATE;

Details:

This stored procedure is working fine in Oracle SQL developer.

When we try to create a universe on top of this stored procedure, We are getting an error

EXCEPTION: CS, Unexpected Behavior: Underflow

Note: I have attached a sample screenshot of the error along with this post.

It would be great , If some one can help us in resolving this issue.

Thanks,

Kamalessh.

4.jpg (12.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 28, 2016 at 01:47 PM

    To be used as the source for an SP universe, the SP must return a REF CURSOR. There's a good example here: https://irfansworld.wordpress.com/2012/11/17/what-you-should-know-about-stored-procedure-universe-in-bi-4-0/

    Add comment
    10|10000 characters needed characters exceeded