Anonymous Block in BIP

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