Re: Webdb multi-part reports, PL/SQL parameters?
Date: 2000/04/20
Message-ID: <=7H+OOK0g+iPvvY5dn+hjzpzO0Js_at_4ax.com>#1/1
On Wed, 19 Apr 2000 21:32:22 +0200, Ton Haver <ton.haver_at_cover.nl> wrote:
>I think this is possible by creating a "dynamic page"
>
>Ton
>
>Kirmo Uusitalo wrote:
>
>> 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?
Thank you for your response.
[Quoted] I really would like to use dynamic pages instead of hard-coded PL/SQL, but I am afraid that passing parameters (such as the deptno) is not supported by WebDB.
Is there a way to pass parameters to a dynamic page, something like:
<HTML> <HEAD> <TITLE>Example</TITLE> </HEAD> <BODY> <ORACLE>select * from dept where deptno=:deptno</ORACLE><H2>Workers in the department</H2>
<ORACLE>select * from scott.emp where deptno=:deptno</ORACLE>
</BODY>
</HTML>
The above code produces
ORA-01008
ORA-01008: not all variables bound
WWV_RENDER_REPORT.SHOW
Without parameters, the usability of the dynamic pages suffers significantly.
Regards,
Kirmo Uusitalo Received on Thu Apr 20 2000 - 00:00:00 CEST