Webdb multi-part reports, PL/SQL parameters?

Hi,
Hello Oracle Gurus,

Is there a way to create a multi-part report in webdb, i.e. a report that would display the results of several queries?

For instance, the results of the following queries should be displayed in "single page" as the report is run:

SQL> select * from dept where deptno=30;

   DEPTNO DNAME LOC
--------- -------------- -------------

       30 SALES CHICAGO SQL> select * from emp where deptno=30;)

    EMPNO ENAME JOB MGR HIREDATE SAL COMM
--------- ---------- --------- --------- --------- --------- ---------

   DEPTNO

        1 John       Manager             27-NOV-99        20         0
       30
        2 Kirmo      Worker              28-NOV-99        40         0
       30

As far as I know, the standard reports created with webdb only produce one single "table". There is a possibility to add advanced PL/SQL code to the report, but so far I have not been able to pass the parameters (such as deptno in the above example) to the PL/SQL code. If that would be possible I believe it should be quite easy to call the dept_emp report from the dept report. Or even better, the dept report could be produced by a PL/SQL procedure.

I believe this is not a unique wish, so there must be a way to fullfill it. Any suggestions? I think one workaround to do this would be to use frames (launch the dept report on top frame and the other to the bottom fram), but I'd rather not use frames as the report should be easily printable as well.

So far I have been using webdb 2.0.5 on NT, but will soon upgrade to 2.2.

Thanks in advance,

Kirmo Uusitalo
If you reply via email, please use my real email address: kirmo.uusitalo[at]iki.fi Received on Wed Apr 19 2000 - 00:00:00 CEST