最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

oracle database - How do I generate a pdf file with bursting in BI publisher? - Stack Overflow

programmeradmin3浏览0评论

I was practicing with the bursting feature in BI Publisher, I scheduled it to send a pdf file by email. The scheduling was confirmed 'success' but when I checked, no pdf file was attached and sent to my folder. This was the query I used in my bursting:

SELECT DISTINCT 'RPT_ITEM_NUMBER'         AS "KEY",
       'RPT_ITEM_NUMBER'              AS "DELIVER_BY",
       'file'                         AS "DELIVERY_TYPE",
           '/My Folder/Drafts'            AS "PARAMETER1",
           'G02344.pdf'                   AS "PARAMETER2",
           'PDF'                          AS "PARAMETER3"
FROM DUAL

I tried to specify the directory in the line: '/My Folder/Drafts' AS "PARAMETER1" but it didn't work. So how do I make sure that there is a file to be sent by bursting?

发布评论

评论列表(0)

  1. 暂无评论