Skip to Content
0
Former Member
Feb 27, 2009 at 02:03 PM

Business Objects XI R2 - Oracle Stored Proc - Deski report failing

20 Views

Business Objects XI R2

Hi All,

I have a stored proc created in Oracle 10 - see bottom for code

I run a deski report on iit - using it as a datasource. This works fine in Desktop Intelligence until I schedule the report from infoview - then I get the following error...

"Object failed to run due to an error while processing on the Job Server"

My other deski reports based on Universes are ok.

____________________________________________________

create or replace procedure test_PROC1

(Test_Rpt_Cur OUT SYS_REFCURSOR)

is

begin

open Test_Rpt_Cur FOR

SELECT ID, FIRSTNAME, LASTNAME

FROM test_table;

end test_proc1;