I have created a report region by selecting "PLSQL Dynamic Content".This region calls the procedure with some parameters.So i want this plsql dynamic content to be in PDF format.
For an easy understanding, I have created an application in Apex.Oracle.Com where i have created a Plsql Dynamic content which calls procedure do display in region.
Step 1: http://apex.oracle.com/pls/apex/f?p=4550:1:15635986742760:::::
Step 2: Workspace : dev_dilip
Pwd : 123456
Step 3: Open PRINT_PDF application and Run the application.
Step 4: Username: firstname.lastname@example.org
Pwd : 123456
The procedure code can be viewed by object browser.
Once user cliks PDF (button inapplication) a new tab should open and that plsql region should in PDF format.
I kindly request all to check and advice me with your valuable suggestion.
SO, you want to print the output of the procedure in pdf format? If so, you can try apex Report Query feature. You can find a number of examples for the same in this forum and in the internet:
Or, have a IR based on a collection; the collection based on a function returning query. And then, use the IR's generic download option to print reports.
I appreciate for quick reply.
I feel that your examples are good, if i go for REPORT region but my requirement is of PL/SQL Dynamic Content region.
As per your approach how can i write Procedure name in an SQL query ?
Not sure why you are sticking to the procedure. You can write a simple sql query as the "Report Query" and include P1_EMPNO ("Include application and session information" option in the Report Query).
BTW, I don't think that you can call procedure within select statements; you can call functions.
For an easy understanding purpose i have created small procedure(EMP details).
My requirement is a procedure of nearly 500-600 line of code which has htp.p(''); stmts calling in Apex environment with PLSQL Dynamic Content.