BI Publisher (MOSC)

MOSC Banner

Anonymous Block in BIP

edited Sep 13, 2023 1:29PM in BI Publisher (MOSC) 10 commentsAnswered ✓

Hi all,

A while ago, the new field "Type of SQL" was introduced when creating a data model.

According to the documentation it allows executing an anonymous PL/SQL block if the option "Procedure Call" is selected.

However, I'm struggling at getting this to work.

The documentation doesn't offer many details or a simple working example.

What I've tried is  this:

DECLARE

   type refcursor is REF CURSOR;

   xdo_cursor refcursor;

BEGIN

  OPEN :xdo_cursor FOR

   SELECT 'test' as test

   FROM dual

END;

Has any of you done this and can share a simple example that works?

(this has also been discussed

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center