Re: Running a Report from a stored PL/SQL Package
Date: Mon, 16 Apr 2007 20:11:41 +0200
Message-ID: <f00e3v$pl1$1_at_news5.zwoll1.ov.home.nl>
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:
http://www.oracle.com/pls/db102/drilldown?levelnum=2&toplevel=b14200&method=FULL&chapters=0&book=&wildcards=0&preference=&expand_all=&result_id=1166123&verb=&word=sys_context#b14200
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Apr 16 2007 - 20:11:41 CEST