Search results
30 wrz 2009 · 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. You can find directions here: http://www.oracle.com/technology/obe/apex/apex31nf/apex31rpt.htm#t1
This tutorial shows you step by step how to create a PL/SQL package specification by using the CREATE PACKAGE statement.
PdfGen - An Oracle PL/SQL PDF Generator. Create an attractive report from a SQL query with capabilities similar to those available in sqlplus report generator, but with control over fonts, margins, page size, and orientation. (See samples directory for PDF files it produced.)
The CREATE PACKAGE statement creates or replaces the specification for a stored package, which is an encapsulated collection of related procedures, functions, and other program objects stored as a unit in the database. The package specification declares these objects.
Creating PL/SQL Package Body. PL/SQL package body contains all the code that implements stored functions, procedures, and cursors listed in the package specification. The following illustrates the syntax of creating package body: CREATE [OR REPLACE] PACKAGE BODY package_name { IS | AS} Code language: SQL (Structured Query Language) (sql)
6 sty 2009 · It is a wrapped PL/SQL package that will generate a PDF as a blob that you could store in the database and/or serve to the user via HTTP. While somewhat limited, it works well and it's cheap.
This tutorial shows you step by step how to create a PL/SQL package body using the CREATE PACKAGE BODY statement.
