Product specifications

Note:
The other IN/OUT cursor parameters of the procedure are ignored.
The unsupported Oracle stored procedures are the following:
• any PL/SQL procedure that does not return result sets through a REF CURSOR parameter
• any PL/SQL procedures having at least one OUT parameter
• any PL/SQL function
• any PL/SQL procedure having one IN/OUT parameter of a type different than a REF CURSOR, for
example, VARRAY
• any PL/SQL Table function
To access Oracle stored procedures, you must do a number of tasks at the server end to allow the SAP
BusinessObjects Business Intelligence platform to connect to a stored procedure. This is explained in
the next sections.
4.3.3 To create a cursor inside a package
In Oracle databases, a package is a database object that contains related PL/SQL types, objects, and
subprograms. You must first create a cursor inside a package before creating an Oracle stored procedure
using the defined cursor.
• In the Oracle database administration system, use the following statement:
CREATE or REPLACE PACKAGE catalog_data AS
TYPE CatCurTyp IS REF CURSOR RETURN
all_objects%ROWTYPE;
END catalog_data;
Caution:
The SAP BusinessObjects Business Intelligence platform does not support packaged stored procedures,
only standalone.
4.3.4 To create an Oracle stored procedure
In the following procedure, you use catcurtyp cursor that you previously created in the package, and
catalog_data.catcurtyp.
• Do one of the following:
a. Write the following statement:
CREATE or REPLACE PROCEDURE get_allobjects(cat_cv IN OUT
catalog_data.catcurtyp) AS
BEGIN
OPEN cat_cv FOR SELECT * FROM all_objects;
END;
2012-03-1530
Learning data access specifics