You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to burst BI Publisher reports that use PL/SQL Procedure call?

edited Mar 10, 2025 2:53PM in BI Publisher Learning Center 1 comment

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!