Oracle Reports (MOSC)

MOSC Banner

Can run_report_object be used in a database procedure or only from Forms?

edited Feb 6, 2015 11:58AM in Oracle Reports (MOSC) Question

I need to execute an ORACLE report and pass an employee number to the report (which has a parameter form for that number) and output to an OS file.  The Form that currently calls the report allows the report to be run for one person at a time.  I need to run it for 20,000 people and save each report to the file system with a unique name.  I thought I might create a database procedure using SET_REPORT_OBJECT_PROPERTY (for the Filename, Destype, Desformat,Report_server, execution_mode, etc) and RUN_REPORT_OBJECT to run the report within a loop.  However, I don't know if I

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center