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