How to burst BI Publisher reports that use PL/SQL Procedure call?
I've used the following PL/SQL code:
DECLARE
TYPE REFCURSOR IS REF CURSOR;
XDO_CURSOR REFCURSOR;
L_DATA_CLOB CLOB;
BEGIN
L_DATA_CLOB :=
L_DATA_CLOB
||'<error_message>'
||'SUCCESS'
||'</error_message>'
||'<status>'
||'OK'
||'</status>';
OPEN :XDO_CURSOR FOR SELECT L_DATA_CLOB FROM DUAL;
END;
The following bursting code has been used:
SELECT
NULL KEY,
'PLSQL_Layout' TEMPLATE,
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
'Test_'|| TO_CHAR(SYSTIMESTAMP, 'YYYYMMDD_HH24MISS')||'.pdf' OUTPUT_NAME,
'EMAIL' DEL_CHANNEL,
'{my_email}' as PARAMETER1,
NULL PARAMETER2,
'{our_usual_sender}' PARAMETER3,
0