Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Running a Report from a stored PL/SQL Package

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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 16 Apr 2007 20:11:41 +0200
Message-ID: <f00e3v$pl1$1@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 - 13:11:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US