Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to call reports 6i or forms 6i directly from oracle procedure

ksrinivasFeb 26 2012 — edited Feb 29 2012
Hi,

Hi,

Env: 6.0.8.25.2 (forms 6i/reports 6i)
Database: Oracle 10g r2

We are running a client server environment and not web based.

---------------------
I want to run the forms 6i or reports 6i directly from a database procedure/function and not by creating a procedure inside a form and then call a report.

Looking for calling forms6i/reports 6i directly from sql*plus commands used inside the PLSQL database procedure/function. (Just like we create a stand alone package/procedure/function).
I have developed many forms and reports and very comfortable in calling reports from forms 6i.

My question was completely different but looks like i was not able to explain properly:
I want to call the forms 6i or reports 6i directly from sqlplus* prompt and through stand alone oracle database procedure/function (procedure created directly in database but not as a program unit within form or report).

There is a requirement to call the form through database scheduling by passing fixed parameters and then generate the report pdf and email automatically to various users.

Also, is there any way to schedule a report automatically so that the report runs automatically in the scheduled time and send out reports to the users. I have developed a email program but looking for scheduling the report or forms 6i.

Thanks,
Srinivas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2012
Added on Feb 26 2012
5 comments
2,334 views