How to call forms 6i (6.0.8.25.2) and pass parameters from PLSQL procedure/function/package
Current Environment:
Database: 10g v2
Forms 6i(D2k): 6.0.8.25.2
Environment:
Forms and Report (compiled versions) are stored in Server1
Database is located on Server2
Can anyone help me with the sample code on how to call the forms 6i and pass parameters from PLSQL.
Actual Requirement:
I have a form developed where i enter the parameter values and generate the report in PDF version.
Want to run this report automatically and send the PDF file generated to various email ids.
Currently users use the form, enter the parameters and run the report when required and this will continue.
Need to schedule this report so that everyday, some scheduled procedure/function/package will run, call the form and pass parameters which in turn will call the report and generate the PDF. Once PDF generated, i will pick that file and will send email using the UTL packages.