Running a Report from a stored PL/SQL Package

#1

I'm building a PL/SQL package that will run a report and then store
the result-set into a table on the database.
The problem I'm having is getting the reports servername dynamically.
I need to get that in order to open the report.
Does anyone know how to do this?
(BTW: I'm using Oracle database 10g, Oracle Reports 10, and a little
program called "PL/SQL Developer" to create the package.)

Thanks in advance!

#2

unique schreef:

Quote:

I'm building a PL/SQL package that will run a report and then store
the result-set into a table on the database.
The problem I'm having is getting the reports servername dynamically.
I need to get that in order to open the report.
Does anyone know how to do this?
(BTW: I'm using Oracle database 10g, Oracle Reports 10, and a little
program called "PL/SQL Developer" to create the package.)

Thanks in advance!

Depending on your version of Oracle, the sys_context

function can be of help.
Of course, documentation is online:
http://www.oracle.com/pls/db102/dril...ntext#b1420 0

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Running a Report from a stored PL/SQL Package

comp.databases.oracle.tools comp.databases.oracle.tools

Running a Report from a stored PL/SQL Package - 04-16-2007 , 08:48 AM

Re: Running a Report from a stored PL/SQL Package - 04-16-2007 , 01:11 PM