Re: Running a Report from a stored PL/SQL Package

From: Frank van Bortel <>
Date: Mon, 16 Apr 2007 20:11:41 +0200
Message-ID: <f00e3v$pl1$>

unique schreef:
> 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:

Frank van Bortel

Top-posting is one way to shut me up...
Received on Mon Apr 16 2007 - 20:11:41 CEST

Original text of this message