Skip to Content
0

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

Nov 23, 2016 at 01:16 PM

155

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Joe Peters Nov 28, 2016 at 01:47 PM
0

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/

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi Joe,

Thanks a lot for your reply.

We have tried to replicate the same thing as per the link you have given to us.

That too ended up without any positive outcome.

We are getting the same error again. Could you please help us

Thanks,

Kamalessh.

0
Kamalesshwaren Thangarajan

Did you use EXACTLY the same code as in that example?

0

Yes. Exactly the same code.

0
Kamalesshwaren Thangarajan

At what point do you get the error? Do you get as far as the SP Editor? Is it the same Underflow error you had before?

0