oracle 如何使用 PL/SQL 创建 PDF 报告
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1498217/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to create PDF reports using PL/SQL
提问by VR3637
Is there PL/SQL package or engine available which would enable the creation of PDF reports from stored procedures?
是否有可用的 PL/SQL 包或引擎可以从存储过程创建 PDF 报告？
回答by scope_creep
If your looking for a freeware or open source package, their is this. I've not used it, but it has good reviews. lPL_FPDFIf you have a budget, then this, which enterprise class product, meaning excellent documentation, is available. plpdf.
如果您正在寻找免费软件或开源软件包，他们就是这个。我没用过，但是口碑不错。 lPL_FPDF如果您有预算，那么这就是可用的企业级产品，意味着出色的文档。plpdf。
The commercial package is written in native Pl/SQL so will be very easy to use. The open source package I don't know.
商业包是用原生 Pl/SQL 编写的，因此非常易于使用。开源包我不知道。
If your running in an Oracle environment, with any of the reports servers, then all of then support PDF being emitted both to the printer and stored in the db as blobs. Its a fairly tedious task to configure it, from what I remember.
如果您在 Oracle 环境中运行，使用任何报告服务器，那么所有这些都支持将 PDF 发送到打印机并作为 blob 存储在数据库中。根据我的记忆，配置它是一项相当乏味的任务。
Hope that gets you started. B
希望这能让你开始。乙
回答by Brian McGinity
PL_FPDF has many problems, such as 32k page limitations and many bugs. I've modified the code and renamed it to wpdf. You can get wpdf here: http://databaseknowledge.com/services.htm
PL_FPDF 有很多问题，例如 32k 页限制和许多错误。我已经修改了代码并将其重命名为 wpdf。您可以在此处获取 wpdf：http://databaseknowledge.com/services.htm
回答by Plasmer
You may want to look into Oracle Application Express to create PDF reports, but depending on how the output is coming out from your stored procedure, it may not be an easy tool to use.
您可能希望查看 Oracle Application Express 来创建 PDF 报告，但根据存储过程的输出方式，它可能不是一个易于使用的工具。
You can find directions here: http://www.oracle.com/technology/obe/apex/apex31nf/apex31rpt.htm#t1
您可以在此处找到说明：http: //www.oracle.com/technology/obe/apex/apex31nf/apex31rpt.htm#t1
回答by Guru
Oracle Application Express - printing featuresnot to be forgotten. You can use interactive reporting from browser and decide what you need to print. You can apply XSLT also and decide the printing format.
Oracle Application Express -不可忘记的打印特性。您可以使用来自浏览器的交互式报告并决定需要打印的内容。您也可以应用 XSLT 并决定打印格式。
