publisher burst log view

jmarc

Summary

publisher burst log view

Content

hello,

For the burst mail,  we can check the status for each sent in bi publisher like the following

is there a way to access theses informations with SQL query from outside publisher ?

best regards

jeanmarc

jmarc

sorry , i don't find any email adress in these table

YGUTTIKONDA

Please review the following note Need the Names of Scheduler Tables in 11.1 of BI Publisher (Doc ID 1618405.1), all the schedule information is stored in the listed tables

• XMLP_SCHED_DATA

• XMLP_SCHED_DELIVERY

• XMLP_SCHED_JOB

• XMLP_SCHED_OUTPUT

Hope this Helps

jmarc

ok,

i find the solution with  the blob column DELIVERY_PARAMETERS in XMLP_SCHED_DELIVERY

select REGEXP_SUBSTR(V_BLOBTOCLOB(DELIVERY_PARAMETERS),'d_emaild_to=.*') from BI12C_BIPLATFORM.XMLP_SCHED_DELIVERY

create or replace function v_blobtoclob(v_blob_in in blob)

return clob is

v_file_clob clob;

v_file_size integer := dbms_lob.lobmaxsize;

v_dest_offset integer := 1;

v_src_offset integer := 1;

v_blob_csid number := dbms_lob.default_csid;

v_lang_context number := dbms_lob.default_lang_ctx;

v_warning integer;

v_length number;

begin

dbms_lob.createtemporary(v_file_clob, true);

dbms_lob.converttoclob(v_file_clob,

v_blob_in,

v_file_size,

v_dest_offset,

v_src_offset,

v_blob_csid,

v_lang_context,

v_warning);

return v_file_clob;

exception

when others then

dbms_output.put_line('Error found');

end;

/